Excel VBA Introduction Part 58.19 - SQL for Excel Files - Inner Joins

By Andrew Gould

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

[abzorbal_off]

Thanks Andrew. Had been on the internet for so many hours for an error I was encountering for a simple issue that parenthesis are required for multiple joins, stumbled upon this video and you explain it so well. Thanks again.

[ousmanetall]

Thanks Andrew you made me really simply understand what INNER JOINS are after lots of time spent to hardly understand it

[rajeshmajumdar]

Thank you so much Andrew!!! You are a true friend always comes and help with your knowledge when I am in need...Godbless You.

[kamilwilczak]

Thank you very much Andrew. Thanks to your ADO/SQL playlist I was able to update my macro and save a lot of time. You are my hero!!

[tejamarneni]

Thank you Andrew for such a great explanation on Inner Joins. My interview went well. They just asked me questions on GROUP BY and delete duplicate records. I was able to solve them this time. I will let you know about the outcome when I receive it.

[aperxmim]

I have struggled with multiple joins in the past using the INNER JOIN, but after watching this video and following along, not anymore

[VincentHardwick]

You know you're listening to an experienced VBA programmer when they sound a note of genuine surprise and delight at being presented with an error message that's actually descriptive and helpful! 😂

[kashifkhanspecial]

Hi Andrew, Thank you so much for this tutorial, this is video in this series I was waiting for.

Thanks again, and take good care of yourself and your family, stay safe and healthy.

Thanks
Kashif

[frikduplessis]

Thank you Andrew once again for a great tutorial 👌 I was so looking forward to this one, and as always very clear, detailed and helpful 👍

[KhalilYasser]

That's incredibly awesome. Thank you very much, my tutor.

[RazzBoo]

I agree with everyone here. Always truly helpful to watch your videos. And they always seem to help me out with what I am working on at the moment. Question; can you share what tool/program you have used to make the database diagram? (I like the look of it)

[daves]

Awesome. Wanted to ask how you created the entity diagram as I have developed tooling in charge which writes ddl from a list of business fields but would like to transform that output to an erd

[grzegorz]

Andre, u are the best. Sorry that I am taking ur time but I have a question. I have two sheets and I would like to compare data from sheet 2020 with sheet 2021. I have the same suppliers' names. first of all, I have to group my sheets separately (owing to for example one of the suppliers has ordered something two times, so I have this supplier x2 in my worksheet, but then how to do the full outer join? how to merge two queries where I have to group them separately, and then merge them! Thank you very much!

[ErickPerez-gwqh]

Hola buen día por favor me puede ayudar en generar inner join con dos bases. ejemplo: tengo base1 con tabla1 y base 2 con tabla 2, me puedes ensenar en realizar el inner join entre base1.tabla1 y base2.tabla2

[lennysheldon]

I'm trying to inner join on two worksheets in the same workbook and I received the following error: "The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time". The purpose of the query is to inter join on the two columns and then perform an update on a separate column when the join matches thanks

[adamanabtawi]

How can I make my VBA code be able to loop through 2 different directories at the same time?
I am pulling a set data from two different folders and graphing them on top of each other too see how much change there is, and my code performs the graphing part well, but when it come to looping into the next set of data from each separate folder to compare them, it ends up picking data from only one of the folders so I end up comparing data from the same folder instead a data set from each folder. How can I avoid that problem? Do I need to use something other than Dir to make it cycle through my files in the two different directories?

[rmscrisostomo]

how do i specify the data type in a SELECT?