Interview Question for Software Developer at Snap-on:

left inner join - all rows on left hand table are read and only those rows that match on the right hand side,
 left outer join - reverse of left,
self join - use alias's to join tables