Hi all, Svein Erling Tysvær <[email protected]> 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
