Question: What is Full Outer Join With Exclusion?
Answer: I got this question after reading my earlier blog post about SQL SERVER – Introduction to JOINs – Basic of JOINs. The question was from my regular client of Comprehensive Database Performance Health Check.
His question was that while I have explained lots of a different kind of join, why I have not explained the Full Outer Join With Exclusion.
While the question is very valid, I did have explained a join type which is NOT INNER JOIN in my tutorial which is actually synonyms of the Full Outer Join With Exclusion. It gives