MS SQL Server Joins Question:

What is Outer Join in SQL server joins?

Tweet Share WhatsApp

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 PDF Read All 49 SQL Server Joins Questions
Previous QuestionNext Question
What is Left Outer Join in SQL server joins?What is Inner Join in SQL server joins?