MySQL LEFT JOIN Keyword

The LEFT JOIN keyword in MySQL returns all records from the left table (table1), and the matched records from the right table (table2). The result is NULL from the right side if there is no match.

Example:

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

The LEFT JOIN keyword is useful for retrieving all records from one table along with matching records from another table, even if there are no matches.