# MySQL JOIN

Implicit Inner Join

SELECT * FROM customers, orders
WHERE customer.id = orders.customer_id;

Explicit Inner Join

SELECT * FROM customers
JOIN orders
  ON customer.id = orders.customer_id;

Left Join

SELECT * FROM customers
LEFT JOIN orders
  ON customers.id = orders.customer_id;


###### tags: `MySQL`