fix left join bug