SQL & PL/SQL

Hi

I am trying to write an sql as below...

select row1, row2,row3 from table1 where row4 in (select row5,row6 from table2 where row7='string');

I know the above syntax is wrong. what i need is, i have to pass two values selected from another table as arguments in, 'in'

please suggest proper syntax to achieve this result.


Thanks,
Aditya