[wesd]

Start by having a strong understanding the various joins first: http://www.sql-join.com/sql-join-types/