Full Outer join is the combination of Right Join and left join. That means we can say that the outer join outputs the entire data present in the dataset. Follow the below diagram to understand the concept better:
Syntax
Select Column from Table1 FULL OUTER JOIN Table2
on Table1.column= Table2.column;Example
We have two tables Stu and Marks1. Refer below to see values in tables:
Stu Table is as follows:
Marks1 table is as follows:
Now if we apply outer join in both the above table. the code is as follows:
select * from Stu s full Outer Join Marks1 m
on s.Roll_no= m.Roll_no;Output
