我有两个表,它们都有相同数量的列,但都没有主键,如下所示:
表A
名称 | 排名 | 类别评级 | |
---|---|---|---|
M1 | 1 | 喜剧电影 | G |
M2 | 2 | 动作 | 系列PG |
您可以联合两个外部联接。例如:
select a.*
from a
left join b on a.name = b.name and a.ranking = b.ranking
where b.name is null
union all
select b.*
from b
left join a on a.name = b.name and a.ranking = b.ranking
where a.name is null
尝试内部连接
SELECT *
FROM table_a
INNER JOIN table_b ON table_a.name = table_b.name AND table_a.ranking = table_b.ranking;