SELECT Table1.* FROM Table1 INNER JOIN Table2 ON Table1.field1 = Table2.field2
SELECT Table1.* FROM Table1 WHERE field1 IN (SELECT field2 FROM Table2)