TSQL Basics Part 17: TWO FULL OUTER JOINS

This is part 17 “two full outer JOINS” of a 19 part series on TSQL Basics. You will first gain an understanding of the differences between each of these types of JOINS, and when they should be used. Then we’ll explore some common uses for JOINS, such as replacing a not in clause with JOIN to get the same results with better performance. You will take home the right foundations to get at the data that you want. Make sure to check of the other parts in this series in my JOIN Types playlist.

>>> Try our JOIN Types Course Today!

Transcription:

Two FULL OUTER JOINS now this can get interesting. We have table one, FULL OUTER JOIN to table two, FULL OUTER JOIN to table three. And if we look at the Venn diagram for that, it’s going to be treating it like a LEFT and RIGHT JOIN between all of those tables. And you can see that the first batch up here is those that would have been caught in the INNER JOIN. And then you’ve got those that would have shown out with shown up with the LEFT OUTER JOIN the table too. And then you’ve got the next batches, those that would have shown up with the LEFT OUTER JOIN to table three. And then the final one is sushi, which nobody has chosen sushi. That’s unfortunate because sushi is really good, but it’s showing up in here because it’s a FULL OUTER JOIN. And if this this has just been a left outer join that sushi would have been overlooked.

Also, just reminder, you can download the join types poster at SteveStedman.com. And this is a poster I created a few years ago that just sort of shows how all the different joins that we’re going to be covering through this presentation are done. It’s handy to print out and keep on your cube wall or near your workspace.

Our JOIN Types Course Comes With:

• Easy to understand lectures with examples

• Assignments

• Sample code to work with

More from Stedman Solutions:

Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!