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

What is Full Outer Join With Exclusion? - Interview Question of the Week #286 join-800x539 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 all NOT common records of both the tables, that means it is actually inverse of the inner join and many often call it Not Inner Join.

Here is how you can represent it with the help of an image.

What is Full Outer Join With Exclusion? - Interview Question of the Week #286 outer%20join%20null

So there you go. Now you know what is the Outer Join w Exclusion. You can read all the different kind of joins in my previous blog post over here.

Here are six-part blog post series I have written based on my last 10 years of experience helping with Comprehensive Database Performance Health Check. I strongly recommend you to read them as they walk you through my business model.

Just reach out to me at pinal @ sqlauthority.com and I will be happy to help you tune your SQL Server’s performance.

Reference: Pinal Dave (https://blog.sqlauthority.com)

, ,
Previous Post
How to Generate Script for SQL Server 2005 from SQL Server 2019? – Interview Question of the Week #285
Next Post
How to Install SQL Server 2019? – Interview Question of the Week #287 – SQL in Sixty Seconds #092

Related Posts

Leave a Reply

Menu