How to join two tables mysql?

mysql inner-join sql

SELECT * FROM table1 LEFT JOIN table2 on table1.id = table2.id

mysql inner-join sql

SELECT ...FROM services AS sJOIN clients AS c  ON s.client = c.idWHERE ...

mysql inner-join sql

SELECT ...FROM services AS sINNER JOIN clients AS c  ON s.client=c.id

CodeHunter