select * from table1, table2
where table1.field1 = table2.field1

SELECT t1.*, t2.*
 FROM table1 t1
  INNER JOIN table t2 ON t1.field1 = t2.field1