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