LEFT OUTER join and RIGHT OUTER join | Oracle SQL fundamentals

Outer #joins are used to match #rows from two #tables. Even if there is no match rows are included. Rows from one of the tables are always included, for the other, when there are no matches, #NULL values are included.
There are three types of outer joins:
Left Outer Join – All rows from the left table are included, unmatched rows from the right are replaced with NULL values.
Right Outer Join – All rows from the right table are included, unmatched rows from the left are replaced with NULL values.
Full Outer Join – All rows from both tables are included, NULL values fill unmatched rows.

00:00 What is Outer Join?
00:26 Left Outer Join
03:06 Relationship
06:15 Right Outer Join

Website: https://www.dbagenesis.com/
Facebook:   / dbagenesis  
Instagram:   / dbagenesis  
Twitter:   / dbagenesis