>>>It depends, but in most cases I tried LEFT JOIN was the fastest method.
>>
>>What is that most case and how it depends? In all cases I tried it was the slowest.
>>Cetin
>
>I think it depends on number of records in each table.
You think:) Ok I understand that. My tests were with large tables,
PS: If you check excution plan of 'in', exists and left join, the latter adds an extra step to other plans.
Cetin