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.
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.
- Consulting 101 – Why Do I Never Take Control of Computers Remotely?
- Consulting 102 – Why Do I Give 100% Guarantee of My Services?
- Consulting 103 – Why Do I Assure SQL Server Performance Optimization in 4 Hours?
- Consulting 104 – Why Do I Give All of the Performance-Tuning Scripts to My Customers?
- Consulting 105 – Why Don’t I Want My Customers to Return Because of the Same Problem?
- Consulting Wrap Up – What Next and How to Get Started
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)