Joining means combination of data from different tables based on common fields. Below video will not only explain different joins but also touch upon

when to use INNER JOIN / when to use LEFT OUTER JOIN etc with a sample data source which can be downloaded below

Download below workbook 

You might like to check below related videos as well

Feedback forum

After learning different types of JOINS now we should learn Troubleshooting joins 

  1. How to Join tables with Null values ?
  2. How to  Join tables with different Data and Date format ?
  3. How to counter duplicate data issue with Join ?