change join to left join