>>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.