Usage and Examples of SQL LEFT JOIN Keyword

SQL Keywords Reference

LEFT JOIN

The LEFT JOIN command returns all rows from the left table, as well as the matching rows from the right table. If there is no match, the result from the right side is NULL.

The following SQL will select all customers and any orders they may have:

　SELECT Customers.CustomerName, Orders.OrderID
　FROM Customers
　LEFT JOIN Orders
　ON Customers.CustomerID = Orders.CustomerID
　ORDER BY Customers.CustomerName;

Note:The LEFT JOIN keyword returns all records from the left table (Customers), even if there is no match in the right table (Orders).

SQL Keywords Reference