What is FULL OUTER JOIN?
Submitted by: AdministratorA 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
Submitted by: Administrator
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
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. |