SELECT a.name, b.sex, a.source from dept_a a LEFT JOIN dept_b b on a.source = b.source
UNION
SELECT a.name, b.sex, b.source from dept_a a right JOIN dept_b b on a.source = b.source
结果
查询结果
SELECT a.name, b.sex, a.source from dept_a a LEFT JOIN dept_b b on a.source = b.source
UNION
SELECT a.name, b.sex, b.source from dept_a a right JOIN dept_b b on a.source = b.source
结果
查询结果