> Thank you Karol for your post.
>
> However, your query did not yield any results either.  I’m not sure what the
> difference would have been between using the left join and the subselect,
> but I’ll take any advice right now.

Very odd situation.

Are the data types of the "account_id" columns the same for all tables?

No one asked if you:

- which FB version you are running?

- are you performing backup/restore using the same FB version (ie. not trying to perform an ODS/version upgrade)?


Sean