>>What do you mean by it's not working? You don't get correct results? It should be the same as your other query with EXISTS.
>
>No, instead of 138 records, I get 20000.
When you don't use LEFT JOIN but just EXISTS conditions, how many ClientID satisfy that criteria?
Do you want to get all these clients information along with extra columns from other tables joined based on that ClientID ?
If it's not broken, fix it until it is.
My Blog