> select * from table where id in (select id from table2) > > would have to be done in at least to queries...
Not really.
SELECT Table.Blah, Table2.Whatever
FROM Table1 INNER JOIN Table2
ON Table1.T1ID = Table2.T1ID
Which does the same thing and in a faster time (aparently)
Taz
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]
