By Andrew Gould

Writing SQL for Excel with ADODB playlist https://youtube.com/playlist?list=PLNIs-AWhQzckUd5i0E1xeSFeBAonYIurK
VBA Working with Databases playlist https://youtube.com/playlist?list=PLNIs-AWhQzclbRVLCZlsFvpz6fz2nPGbt

Get files here https://www.wiseowl.co.uk/vba-macros/videos/vba-ado-net-recordsets/sql-excel-full-outer-join/

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:
https://www.youtube.com/channel/UCbi5G5PjWBaQUFy7XU_O7yw/join
Or you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

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

Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Power BI, DAX, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, Microsoft Access and more