Select * from TopTable WHERE EXISTS (select * from table2 inner join table1 on table1.facID = table2.facID and table1.billingID = table2.billingID WHERE toptable.number = table2.bill_number AND toptable.date = table2.service_date )>
>Select * from TopTable >toptable.number, toptable.date IN >(select table2.bill_number, table2.service_date from table1 > inner join table2 > on table1.facID = table2.facID > and table1.billingID = table2.billingID) > >If I run the sub query by itself..it works fine. >I'm just not sure if you can match the fields this way.