Use `join` instead of `left join`