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-nested-subqueries

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 nest multiple levels of query to answer more complicated questions about your data. You'll build on what you learnt in the previous lesson on basic subqueries to nest queries up to four levels (and up to fifty if you really want to!).

Chapters
00:00 Topic List
00:31 The Basic Setup
02:06 A Reminder of Basic Subqueries
03:02 Using Subqueries in the Where Clause
04:21 Nesting a Subquery in a Subquery
05:32 Changing the Example
07:07 Nesting Queries to Three Levels
09:10 Rearranging the Code
10:37 Nesting Queries to Four Levels
11:57 Adding More Criteria with Subqueries
13:52 Returning Multiple Values from a Subquery
15:03 Using the IN Operator with Subqueries

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