TIL the difference between INNER and LEFT joins.