Hey all!

I'm trying to do something simple. I'd like to match 2 fields on a subquery.
Is this possible?

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.
thanks,
Dan