3 ms·
How about select * from outertable, (select *, outerid from table1,table2 where table1.table2id = table2.ID and table2.othertype = 1234) t12 where outertable.I
by snidane 8y ago
How about
select *
from outertable,
(select *, outerid from table1,table2 where table1.table2id = table2.ID and table2.othertype = 1234) t12
where outertable.Id =\ t12.outerid