MS SQL Server Joins Interview Question:

What is FULL OUTER JOIN?

Submitted by: Administrator

A full outer join will combine results of both left and right outer join. Hence the records from both tables will be displayed with a NULL for missing matches from either of the tables.

Example: To display employees who have a bonus and to display bonus even if he is not an employee.
Select * From employee FULL OUTER JOIN bonus ON employee.bonusID=bonus.bonusID
Submitted by: Administrator