差點就想說不可能 達到 --> 查了一下如下
SELECT a.name, b.grade, a.number
FROM a INNER JOIN b ON a.name = b.name
UNION ALL
SELECT a.name, IIF(b.grade IS NULL,0,b.grade), a.number
FROM a LEFT JOIN b ON a.name = b.name
WHERE (((b.grade) Is Null))
UNION ALL
SELECT b.name, b.grade, IIF(a.number IS NULL,0,a.number)
FROM a RIGHT JOIN b ON a.name = b.name
WHERE a.name is null
|