See
http://groups.google.nl/groups?hl=nl...er.programming

Gert-Jan


"Trev@Work" wrote:
>
> Which is more efficient:
>
> Select * from table1 where id in (select id from table2)
>
> or
>
> Select * from table1 where exists(select * from table2 where
> table2.id=table1.id)

--
(Please reply only to the newsgroup)