In oracle this used to work (If my memory serves me right)..

Select * from tablea where (col1,col2) in (Select col1,col2 from tableb)

You could try that