What is Full Outer Join With Exclusion? – Interview Question of the Week #286


 

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