Fixed left join.