Hi all,

Svein Erling Tysvær <svein.erling.tysvaer@...> ha scritto:

> Rewrite your query to
>
> select id from TEST T where exists(select * from subquerytable sq
> where sq.id2 = t.id2)

That query seems logically equivalent to

SELECT id FROM TEST T JOIN SUBQUERYTABLE SQ ON (T.id2=SQ.id2)

Are there any reward to complicate SQL sentences?

MM