How to Make an Inner Join and Left Join in Microsoft Access and Learn How to Compare Lists

In this video we are going to explore the two main SQL joins that are used in data analytics and data transformation. Follow through a detailed example and create your own query at the same time.

Also learn how to compare two lists with a mismatch query (aka. find unmatched query) to show which items are in one list but not the other and vice-versa. This example shows you how to make two queries for your lists, then compare those two queries using a mismatch query. These examples use a small amount of data, but you can imagine comparing lists with tens of thousands or even millions of rows using this technique.

Related Videos:
How to Make an Inner Join and Left Join in Microsoft Access and Learn How to Compare Lists
You are watching this video now!
How to Make a Query by Joining Tables and Making a Calculated Column in Microsoft Access
How to Use an Append Query in MS Access: mdb to accdb
Multi-Table Update Query in MS Access
How Use Delete Queries in MS Access'
How to use In.. Not In.. to include or exclude multiple values in Microsoft Access
How to Use Wildcards in MS Access Queries
How to Use Double and Single Quotes in MS Access Queries

Follow us on social media:

Get Microsoft Office including Access:

Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try:

Data Analytics | 2 Main SQL Joins (Inner Join and Left Join) and Learn How to Make a Mismatch Query
Data Analytics
Data Transformation
Data Analysis
Microsoft Access
mismatch query in access
compare two lists
Find Unmatched Query
Data Analytics Techniques
compare 2 tables and find matching data
sql joins
sql joins tutorial
data science
access tutorial
find unmatched query
Sean MacKenzie

[anticlimatechangeclimi]

Very helpful I was looking for it ... thanks a lot .. you are a saver

[ralphlewis]

Awesome and explained very well thankyou

[audreyhuang]

I wonder if we can get the data used in the video so we can follow along. Thanks

[chantal]

Thank you very much, this is what I need. Do you maybe also have a video how to compare the data in two different access? Regards