WEB DEVELOPER SITE
HTMLCSSJAVASCRIPTSQLPHPBOOTSTRAPJQUERYANGULARXML
 

SQL LEFT JOIN Keyword


SQL LEFT JOIN Keyword

The LEFT JOIN keyword returns all rows from the left table (table1), with the matching rows in the right table (table2).The result is can run without before

SQL LEFT JOIN Syntax

SELECT column_name(s)
FROM table1
LEFT JOIN table2
ON table1.column_name=table2.column_name;

or:

SELECT column_name(s)
FROM table1
LEFT OUTER JOIN table2
ON table1.column_name=table2.column_name;

PS! In some databases LEFT JOIN is called LEFT OUTER JOIN.

SQL LEFT JOIN


Database

In this tutorial we will use the database.

Below is a selection from the "Customers" table:

CustomerID PersonName Username Password Email Phone
1

Daniel L. Foster Supoer OSaumu1wee DanielLFoster@rhyta.com 765-214-7052
2 Annie J. Karns/td> Goll1956 ohl5aeJ0me helpbeginsnow.com 302-570-9752
3 Jesse B. Lafave Siounincid aij2Cheiceph iamfeelinglousy.com 812-923-1849

And a selection from the "Orders" table:

OrderID CustomerID EmployeeID OrderDate ShipperID
51 5 501 November 14, 1989 3
52 4 502 November 10, 1994 1
53 2 503 November 15, 2005 2

SQL LEFT JOIN Example

The following SQL statement will return all customers, and any orders they might have:

Example

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 the rows from the left table (Customers), even if there are no matches in the right table (Orders).