>Only one expression can be specified in the select list when the >subquery is not introduced with EXISTS >>
>select Table1.Field1 from Table1 where Tabel1.Field1 in (select Table2.Field1, Table2.Field2 from Table2 where >Table2.Field2 in (select Table3.Field2 from Table3)) >>
select Table1.Field1 from Table1 where EXISTS(select null from table2 join table3 on table2.field2 = table3.field2 and table2.field1 = table1.field1)Exists will stop looking once it found a match, and the inner join of table2 and table3 automatically filters records that exist in both tables.