1.

What Is Full Outer Join?

Answer»

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.bonus=bonus.bonus

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.bonus=bonus.bonus


Discussion

No Comment Found

Related InterviewSolutions