Excel VBA Introduction Part 58.19 - SQL for Excel Files - Inner 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-inner-join/

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, 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 write inner joins in your SQL queries for Excel files to look up related information in different worksheets. You'll learn a bit about relational database design including what primary keys, foreign keys and one-to-many relationships are. You'll see how to join two tables using an inner join to match rows based on a common value. You'll see an alternative way to do the same thing without using an inner join. You'll also learn the syntax required to include multiple tables in the same query and finally how to apply criteria and sorting to the results.

Chapters
00:00 Topic List
00:40 The Basic Setup
03:07 How the Data is Organised
06:51 Writing a Basic Inner Join
08:42 Selecting Columns from Multiple Tables
10:07 Referring to Columns with the Same Name
12:16 Using Table Aliases
14:21 Joining Tables without using Joins
18:16 To Join or not to Join
20:30 Joining Multiple Tables
23:59 Including More Tables
27:26 Adding Criteria and Sorting

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.19 - SQL for Excel Files - Inner Joins канала WiseOwlTutorials