JOIN Operations

Retrieves matching records from both tables.

SELECT employees.name, departments.department_name
FROM employees
INNER JOIN departments ON employees.department_id = departments.id;

Retrieves all records from the left table and matching records from the right table.

SELECT customers.name, orders.order_id 
FROM customers
LEFT JOIN orders ON customers.id = orders.customer_id;