Excel VBA Introduction Part 58.26 - SQL for Excel Files - Nested Subqueries
Excel VBA Introduction Part 58.27 - SQL for Excel Files - Correlated Subqueries
Excel VBA Introduction Part 58.25 - SQL for Excel Files - Basic Subqueries
Excel VBA Introduction Part 58.6 - SQL for Excel Files - Text Criteria and the Like Operator
Excel VBA Introduction Part 58.20 - SQL for Excel Files - Outer Joins
Excel VBA Introduction Part 58.13 - SQL for Excel Files - Grouping Rows
Excel VBA Introduction Part 58.18 - SQL for Excel Files - Union Queries from Multiple Files
Excel VBA Introduction Part 58.23 - SQL for Excel Files - Merge Worksheets Side by Side
Excel VBA Introduction Part 58.21 - SQL for Excel Files - Constructing Full Outer Joins
Excel VBA Introduction Part 58.31 - SQL for Excel Files - Split a Table into Separate Sheets
Excel VBA Introduction Part 58.17 - SQL for Excel Files - Union Queries with Total Rows
Accessing Databases from Excel VBA
Introduction to SQL Programming for Excel Users Part 20 - Basic Subqueries
How to simulate a full outer join in Excel? (3 Solutions!!)