MS SQL Server Joins Question:
Download Job Interview Questions and Answers PDF
What is Outer Join in SQL server joins?
Answer:
A join that includes rows even if they do not have related rows in the joined table is an Outer Join. You can create three different outer join to specify the unmatched rows to be included:
☛ Left Outer Join
☛ Right Outer Join
☛ Full Outer Join
☛ Left Outer Join
☛ Right Outer Join
☛ Full Outer Join
Download SQL Server Joins Interview Questions And Answers
PDF
| Previous Question | Next Question |
| What is Left Outer Join in SQL server joins? | What is Inner Join in SQL server joins? |