What is RIGHT OUTER JOIN?
Submitted by: AdministratorA 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
Submitted by: Administrator
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
Submitted by: Administrator
Read Online MS SQL Server Joins Job Interview Questions And Answers
Top MS SQL Server Joins Questions
| ☺ | What is inner join? Explain with an example? |
| ☺ | What is Merge join? |
| ☺ | What is LEFT OUTER JOIN? |
| ☺ | What is OUTER JOIN? |
| ☺ | What is FULL OUTER JOIN? |
Top New MS SQL Server Categories
| ☺ | SQL Server Database Administrator Interview Questions. |
| ☺ | SQL Server Service Broker Interview Questions. |
| ☺ | SQL Server Locks Interview Questions. |
| ☺ | SQL Server Constraints Interview Questions. |
| ☺ | MS SQL Data Mining Interview Questions. |
