MS SQL Server Joins Question: Download SQL Server Joins PDF
What is RIGHT OUTER JOIN?
Answer:
A right outer join or a right join returns results from the table mentioned on the right of the join irrespective of whether it finds matches or not. If the ON clause matches 0 records from table on the left, it will still return a row in the result—but with NULL in each column.
Example: To display Bonus irrespective of whether they are an employee or not.
Select * From employee RIGHT OUTER JOIN bonus ON employee.bonusID=bonus.bonusID
Example: To display Bonus irrespective of whether they are an employee or not.
Select * From employee RIGHT OUTER JOIN bonus ON employee.bonusID=bonus.bonusID
| Previous Question | Next Question |
| What is LEFT OUTER JOIN? | What is FULL OUTER JOIN? |