Excel VBA Introduction Part 58.21 - SQL for Excel Files - Constructing Full Outer Joins

By Andrew Gould

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:

This video shows how to simulate a full outer join in your SQL queries for Excel files. You'll learn how to combine the results of a left outer and a right outer join while removing the duplicated rows. You'll see how to use Union and Union All queries to control the duplication of rows in the output. You'll also learn how to combine multiple tables in the same query ensuring that you see every row from every table included.

Chapters
00:00 Topic List
00:34 The Basic Setup
02:45 Recap of Inner and Outer Joins
06:49 Simulating a Full Outer Join
09:39 Including Duplicated Rows
11:42 Using a Union All Query
14:21 Including an Extra Table
16:44 Appending the Unmatched Rows

[pranavprakash]

I can't thank you enough for this, i had huge data manipulations and i was trying to solve them using loops, however translating sheets to record sets and executing queries was the fastest way around it. Glad you have shared such content for free. Thank you so much and keep up the awesomeness ❤️.

[frikduplessis]

Thank you Andrew as always, I really don't want this series to end,

[KhalilYasser]

Very useful indeed. Thank you very much.

[kartickchakraborty]

Sir, I'm from India, one of your subscribers. I wish, I could see you and touch your feet. I earnestly request you come in front of the camera and show your face. I want to see you only once. You're my most beloved Guru. Whatever, I'm today, just for your blessings. I've learnt lot of things from you. May God bless you!!

[singhalmonica]

Do u have videos on Google app. Scripts too.