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-merge-worksheets-side

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 you how to merge multiple worksheets using a combination of union queries and outer joins. You'll use a union query to create a master list of values to join on and use this query to populate a derived table subquery. You'll join other worksheets to the results of the subquery to produce a side-by-side merged set of results.

Chapters
00:00 Topic List
00:42 The Basic Setup
02:36 Joining Two Worksheets
04:42 Outer Joins
08:41 Creating a List of Genres with Union
10:13 Joining to a Derived Table Subquery
13:18 Replacing Nulls with Zero
14:56 Joining More Worksheets
16:47 Joining the Remaining Worksheets
21:30 Adding a Where Clause
22:47 Adding More Conditions

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