>And as Antonio pointed out, the FROM (or JOIN) needs to reference the Client table.
>
>Unless what you're writing here is intended to be a correlated subquery, where the reference to Client is an outer reference....but again, if you can clarify what you're trying to do, that would probably help.
I believe the last message posted explains it better.