table1 INNER JOIN table2 ON table1.field1 = table2.field2

SELECT *
FROM table1 INNER JOIN table2
ON table1.field1 = table2.field2
WHERE tablex.fieldx=xxx