MS SQL Server Joins Question:
Download Questions PDF

What is Outer Join in SQL server joins?

SQL Server Joins Interview Question
SQL Server Joins Interview Question

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

Download SQL Server Joins Interview Questions And Answers PDF

Previous QuestionNext Question
What is Left Outer Join in SQL server joins?What is Inner Join in SQL server joins?