fix: use coalesce instead of drop_duplicate_keys for join

fix: use coalesce instead of drop_duplicate_keys for join #2405