>>Now after reviewing Borislav's response I see I didn't pay enough attention.
>>
>>Only if you reference XXX table in the WHERE the query will act as an INNER JOIN.
>
>
>Only if you reference XXX table FOR NOT NULL VALUES in the WHERE the query will act as an INNER JOIN.
>
>next is not like to an INNER JOIN
>
>...
>LEFT JOIN XXX ...
>WHERE XXX.field IS NULL
>
Good amendment.
If it's not broken, fix it until it is.
My Blog