>>So, you have 537 clients that satisfy both conditions. When you LEFT JOIN with just one table, how many rows do you get back?
>>
>>When you left join with the other table, how many rows do you get back?
>
>All is ok now, thanks
I see. I was just thinking what could be different between these 2 selects as they seemed to be the same to me. Glad you found the difference.
If it's not broken, fix it until it is.
My Blog