Search Wisdom Axis for specific information

SQL Left Outer Join with Examples, Diagram and Images in Oracle, MySQL, PostgreSQL, MariaDB, IBM DB2, Sybase, SQL Server and Teradata.

SQL INTERVIEW QUESTIONS - INDEX

 SQL JOINS: INNER, LEFT, RIGHT, FULL OUTER JOINS What is SQL INNER JOINS What is SQL LEFT OUTER JOINS What is SQL RIGHT OUTER JOINS What is SQL FULL OUTER JOINS
See All

SQL Joins: What is SQL LEFT OUTER JOIN? Explain with examples.

 SQL: LEFT (OUTER) JOIN
The ‘Left (Outer) Join’ always returns ‘All the records from LEFT Table’ and ‘Matching Records’ from ‘RIGHT Table’.

The following are the tables used to explain joins with examples. TABLE – A: customers_table
customer_number customer_name city state country
101 John Miller Los Angeles CA USA
401 David Smith Las Vegas NV USA
501 Ted Williams Chicago IL USA
601 Hamilton Morris New York NY USA
901 Franklin Floyd Austin TX USA
TABLE – B: orders_table
order_number customer_number order_date
1010505 101 2021-06-06
1010506 201 2021-06-06
1010507 501 2021-06-06
1010508 701 2021-06-06
1010509 901 2021-06-06

SQL JOINS: LEFT (OUTER) JOIN
"The ‘Left (Outer) Join’ always returns ‘All the records from LEFT Table’ and ‘Matching Records’ from ‘RIGHT Table’."


The following is the pictorial view of the LEFT (OUTER) JOIN:


LEFT (OUTER) JOIN Example SQL Code:

SELECT customers_table.customer_number,
customers_table.customer_name,
orders_table.order_numer,
orders_table.order_date
FROM orders_table
LEFT OUTER JOIN customers_table
ON orders_table.customer_number = customers_table.customer_number;

LEFT OUTER JOIN Example SQL Code Execution Results:

customer_number customer_name order_number order_date
101 John Miller 10101505 2021-06-06
401 David Smith
501 Ted Willimas 10101507 2021-06-06
601 Hamilton Morris
901 Franklin Floyd 10101509 2021-06-06