LEFT OUTER JOIN in SQL
JOINING always works between two or more tables. How LEFT OUTER JOIN worked, let's understand with an example of two tables named table one LEFT_Table and table two RIGHT_Table. In LEFT OUTER JOIN, it returns all rows from the LEFT_Table that do not exist in the RIGHT_Table in the result.
Read The Full Tutorial on SQL
- JOINS in SQL
- LEFT JOIN in SQL
Query Look Like of LEFT OUTER JOIN
SELECT *
FROM LEFT_Table
LEFT [OUTER] JOIN RIGHT_Table
ON LEFT_Table.column_name = RIGHT_Table.column_name;