fix: use left join when adding tables instead of inner join

fix: use left join when adding tables instead of inner join #2674