各位大神，请问下
A和B两个数据集中，找出A的ID号和B的ID号之间的差集怎么实现呢？
SELECT
COALESCE(A.ID, B.ID) AS ID,
A.Name AS A_Name,
B.Name AS B_Name
FROM
A
FULL OUTER JOIN
B ON A.ID = B.ID
WHERE
A.ID IS NULL OR B.ID IS NULL
A过滤B连接做一行，B过滤A连接做一行，A B做条件属性，右边关联为空的行高为0
1min目标场景问卷
立即参与
