SELECT * FROM Table1, Table2 WHERE Table1.FieldA = Table2.FieldB
SELECT * FROM Table1 INNER JOIN Table2 ON Table1.FieldA = Table2.FieldB