Excel VBA Introduction Part 58.20 - SQL for Excel Files - Outer Joins

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-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 explains how to use left and right outer joins in your SQL queries for Excel files. You'll learn why inner joins don't always return all the results you expect and how to use an outer join to ensure that you always return all of the rows from one of the tables involved in the join. You'll see how to use criteria to find the unmatched rows from a table and find all the invalid entries in a joined table.

Chapters
00:00 Topic List
00:42 Basic Setup
02:39 A Simple Inner Join
05:36 Creating a Left Outer Join
09:13 Creating a Right Outer Join
10:56 Changing Between Left and Right Joins
12:35 Showing Unmatched Records
15:11 Joining Another Table
18:08 Using an Outer Join to Return All Results
20:36 Returning Only the Invalid Rows
21:43 Returning the Unmatched Rows
22:36 Joining More Tables

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

Видео Excel VBA Introduction Part 58.20 - SQL for Excel Files - Outer Joins канала WiseOwlTutorials