MS SQL Server Joins Interview Question:

What is Outer Join in SQL server joins?

Submitted by: Muhammad

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
Submitted by: Muhammad