>>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
If it's not broken, fix it until it is.
My Blog