Sub Queries or Joins

http://logicalread.solarwinds.com/use-sql-server-joins-or-subqueries-mc03/#.VcKISvmqqko
https://www.webucator.com/tutorial/learn-sql/subqueries-joins-unions.cfm