>I prefer:
>
>select Table1.*
>FROM Table1
>INNER JOIN Table2 ON Table1.pk_fld = Table2.pk_fld and Table1.fld2 = '123'
>
Boris,
You know well enough that the result would be different than EXISTS in case of 1 to Many.
If it's not broken, fix it until it is.
My Blog