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 https://www.youtube.com/watch?v=rq_oqznypFo How to Use an Append Query in MS Access: mdb to accdb https://www.youtube.com/watch?v=4jQFRDj10fI Multi-Table Update Query in MS Access https://www.youtube.com/watch?v=9CBxtBylSvE How Use Delete Queries in MS Access' https://www.youtube.com/watch?v=jT3VzpQMxk8 How to use In.. Not In.. to include or exclude multiple values in Microsoft Access https://www.youtube.com/watch?v=Ak06tav90oI How to Use Wildcards in MS Access Queries https://www.youtube.com/watch?v=uEnbT-UvPd0 How to Use Double and Single Quotes in MS Access Queries https://www.youtube.com/watch?v=y-1Kkp_3dCw Follow us on social media: https://www.facebook.com/mackenziedataanalytics/ https://twitter.com/seamacke https://www.instagram.com/seamacke/ https://www.reddit.com/user/seamacke https://www.linkedin.com/in/psmackenzie/ Get Microsoft Office including Access: https://click.linksynergy.com/fs-bin/click?id=BdGJecFFM8A&offerid=1160033.10004289&type=3&subid=0 Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try: https://www.tubebuddy.com/seanmackenziedataengineering 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