Assuming that f1 and f2 are fields in table1 and that the in works the same way in oracle as sql...
Select * from table1 inner join table2 on table1.f1=table2.f1 and table1.f2=table2.f2
HTH
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability