MS SQL Server Joins Question: Download SQL Server Joins PDF
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.bonusID=bonus.bonusID
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
| Previous Question | Next Question |
| What is RIGHT OUTER JOIN? | Explain RDBMS? |