--> 测试数据：[tb]
IF OBJECT_ID('[tb]') IS NOT NULL DROP TABLE [tb]
GO 
CREATE TABLE [tb]([JO] VARCHAR(1),[QTY] INT)
INSERT [tb]
SELECT 'A',10 UNION ALL
SELECT 'A',20 UNION ALL
SELECT 'A',30 UNION ALL
SELECT 'B',4 UNION ALL
SELECT 'B',6
--------------开始查询--------------------------

SELECT * FROM [tb]
UNION ALL
SELECT [JO]+'合计',SUM([QTY]) FROM tb GROUP BY [JO]+'合计'
ORDER BY [JO]
----------------结果----------------------------
/* 
JO    QTY
----- -----------
A     10
A     20
A     30
A合计   60
B     4
B     6
B合计   10
*/

------解决方案--------------------
探讨


[Quote=引用:]

不行啊，出现错误提示：
all queries in an sql statement containing a union operator must have an equal number of expressions in their target lists


------解决方案--------------------
你这是提示列数不匹配啊。