Скачать или смотреть Excel VBA Introduction Part 58.26 - SQL for Excel Files - Nested Subqueries

By Andrew Gould

Writing SQL for Excel with ADODB playlist    • Excel VBA Writing SQL for Excel using ADODB  
VBA Working with Databases playlist    • Excel VBA Working with Databases  

Get files here https://www.wiseowl.co.uk/vba-macros/...

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:
   / @wiseowltutorials  
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