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