SQL LEFT JOIN

SQL LEFT JOIN query returns all records from the LEFT TABLE (table_1), and the all matching record from the RIGHT TABLE (table_2), even if there are no matches in the right table;

That means if the ON clause matches zero records in the right table; then the JOIN will still return a row in the result, but with NULL in each column from the right table.

LEFT JOIN Syntax

SELECT column_name(s)
FROM table_1
LEFT JOIN table_2
ON table_1.column_name = table_2.column_name;

Example With Two Tables

Customers Table

Simple Customers record table & the name of the table is CUSTOMERS. The Column(s) name of the table like [ID, NAME, EMAIL, ADDRESS, and SALARY]:

Orders Table

This is a sample ORDER table; The columns of the table are [OID, DATE, CUSTOMER_ID, and AMOUNT]:

Mapping Image Of LEFT JOIN

JOIN Both Table Using LEFT JOIN

SELECT ID, NAME, DATE, AMOUNT
FROM CUSTOMERS
LEFT JOIN ORDERS
ON CUSTOMERS.ID = ORDERS.CUSTOMER_ID;

Result Look Like

SQL LEFT OUTER JOIN

A LEFT OUTER JOIN used to return a result set that contains all rows in the LEFT TABLE (table_1) that do not exist in the RIGHT TABLE (table_2).

Basically it means, LEFT OUTER JOIN used to preserves the unmatched rows from LEFT TABLE, JOIN with a NULL in the RIGHT TABLE.

Mapping Image Of LEFT OUTER JOIN

LEFT OUTER JOIN Syntax

SELECT *
FROM table_1
LEFT [OUTER] JOIN table_2
ON table_1.column_name = table_2.column_name;