How to create a SQL inner join and outer join: Basics to get started: "SQL Server expert Robert Sheldon explains the two primary types of SQL joins – SQL inner join and SQL outer join – and provides examples on how to use them for a customized result set."