SQL JOIN Syntax with AdventureWorks Example

Using an example query exectued on the AdventureWorks database, I cover JOIN syntax, tables aliases, join types, and the effect of the join type on output.