Joins

Using INNER JOIN/SELF JOIN to allow for smaller indexes

NOT IN versus LEFT JOIN

IN versus INNER JOIN