In full join all the records of both the table will come in resultant table , it doesn't depend on matching the fields . It is the combination of both left and right join . If matches not found then it will return null .Sometime it is also called Full Outer Join . Syntax :
select * from table1 full outer join table2 on table1.column_name = table2.column_name ;
0 Comment(s)