本帖最后由 wwbb 于 2024-5-24 10:04 编辑
SELECT [名称], SUM([数量]) AS 合计数量
FROM (
SELECT [名称], [数量] FROM [表1]
UNION ALL -- 不去重,用UNION ALL;去重,用UNION
SELECT [名称], [数量] FROM [表2]
) AS combined_tables
GROUP BY [名称]
- <div><span style="color: #0000ff;">SELECT</span> [名称], <span style="color: #c700c7;">SUM</span>([数量]) <span style="color: #0000ff;">AS</span> 合计数量
- <span style="color: #0000ff;">FROM</span> (
- <span style="color: #0000ff;">SELECT</span> [名称], [数量] <span style="color: #0000ff;">FROM</span> [表1]
- <span style="color: #778899;">UNION</span> <span style="color: #778899;">ALL</span> <span style="color: #008000;">-- 不去重,用UNION ALL;去重,用UNION </span>
- <span style="color: #0000ff;">SELECT</span> [名称], [数量] <span style="color: #0000ff;">FROM</span> [表2]
- ) <span style="color: #0000ff;">AS</span> combined_tables
- <span style="color: #0000ff;">GROUP</span> <span style="color: #0000ff;">BY</span> [名称]</div>
复制代码
不知道是否满足需求,仅供参考
|