MS SQL Server Joins Question:
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
Previous Question | Next Question |
What is Left Outer Join in SQL server joins? | What is Inner Join in SQL server joins? |