DBA FIGHT

These queries are equivalents?
Same results?
Same performance?

select *
from table1 t1
where t1.a in
  (
   select t2.a
   from fable2 t2
   where t1.b = t1.a
  )

select *
from table1 t1

     table2 t2
where t1.a in t2.a
and t1.b = t1.a Received on Tue Jun 24 2003 - 04:28:24 CDT