>>>When you have INNER join it doesn't matter.
>>>But if you have right or left join the condition should be in the JOIN not in WHERE.
>>
>>Thank Boris
>>
>>can you point me at an explanation of that rule. I think aomi did a while ago but I can't finr the message.
>>
>>No worries if you can't :-)
>
>See
>Why LEFT JOIN doesn't bring records from the LEFT table

Thank Naomi. I remembered you mentioning this a while ago