====== JOIN Operations ======

==== INNER JOIN ====


Retrieves matching records from both tables.
<code>
SELECT employees.name, departments.department_name
FROM employees
INNER JOIN departments ON employees.department_id = departments.id;
</code>

==== LEFT JOIN ====


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

<code>
SELECT customers.name, orders.order_id 
FROM customers
LEFT JOIN orders ON customers.id = orders.customer_id;
</code>