Here’s a great tutorial for beginners (or refresher for seasoned pros) on the basics of SQL Joins (Inner, Left, Right, Full Join).