SQL Full Joins

SQL Full Joins

Full Join keyword returns all rows from the left table (table1) and from the right table (table2). It is the combination of Left join and Right Join.

	
SELECT column_name
FROM table1
FULL OUTER JOIN table2
ON table1.column_name=table2.column_name;

Employee table

Payment table

	
SELECT Employee.Emp_id,Employee.name, Payment.salary
FROM Employee
FULL OUTER JOIN Orders
ON Employee.Emp_id=Payment.Payment_id

After execute above query, result show like below;