>>Not always. The EXISTS can be replaced with LEFT JOIN, but LEFT JOIN cannot be replaced with EXISTS if columns from the table on the right of join included in the select column list.
>>
>>>>
>>>>They are not the same, Mike. JOIN and EXISTS are two different animals
>>>
>>>Two different means to the same end. My point stands.
>
>
>
>>The EXISTS can be replaced with LEFT JOIN
>
>Not always
Functionally, always
--sb--