语句返回插入到另外一个表中

[duote1]

SELECT sum(不良数)
FROM sheet1
WHERE 位置 Like '*Q4002*' And 责任='来料';

union

SELECT sum(不良数)
FROM sheet1
WHERE 位置 Like '*Q4003*' And 责任='来料';

union

UNION SELECT sum(不良数)
FROM sheet1
WHERE 位置 Like '*Q4004*' And 责任='来料';

这是我写的sql语句 可是我返回的结果只是个数字而已 为了表示清楚 能不能给每个结果起个名字

如我返回的结果是
10
15
28
我想要的显示结果是
不良数A 10
不良数B 15
不良数C 28


问题1：请问这样的sql语句怎么写呢


问题2：
如果我想把我统计返回的结果 插入到另外一个表sheet中
insert into sheet（A,B,C）
。。。。。。接着又怎么写语句啊

[cd731107]

SELECT 不良数='不良数A',sum(不良数)
FROM sheet1
WHERE 位置 Like '*Q4002*' And 责任='来料';

union

SELECT '不良数B',sum(不良数)
FROM sheet1
WHERE 位置 Like '*Q4003*' And 责任='来料';

union

UNION SELECT '不良数C',sum(不良数)
FROM sheet1
WHERE 位置 Like '*Q4004*' And 责任='来料';

[叶子]

SELECT '不良数A',sum(不良数)
FROM sheet1
WHERE 位置 Like '*Q4002*' And 责任='来料';
union
SELECT '不良数B',sum(不良数)
FROM sheet1
WHERE 位置 Like '*Q4003*' And 责任='来料';
union
SELECT '不良数C' sum(不良数)
FROM sheet1
WHERE 位置 Like '*Q4004*' And 责任='来料';

[SQL77]

SELECT '不良数A‘ AS 不良数,sum(不良数)
FROM sheet1
WHERE 位置 Like '*Q4002*' And 责任='来料';

union ALL

SELECT '不良数B‘ AS 不良数,sum(不良数)
FROM sheet1
WHERE 位置 Like '*Q4003*' And 责任='来料';

union ALL


SELECT '不良数C‘ AS 不良数,sum(不良数)
FROM sheet1
WHERE 位置 Like '*Q4004*' And 责任='来料';

插入语法F1,联机帮助

[叶子]

[Quote=引用 2 楼 maco_wang 的回复:]

SQL code

SELECT '不良数A',sum(不良数)
FROM sheet1
WHERE 位置 Like '*Q4002*' And 责任='来料';
union
SELECT '不良数B',sum(不良数)
FROM sheet1
WHERE 位置 Like '*Q4003*' And 责任='来料';
union
SELECT '不良数C' sum(不良数)
FROM shee……
[/Quote]
'不良数C'后面我少写了一个逗号...
bty:你后面多了个union，我去掉了...

[--小F--]

insert into sheet(a,b)
select * from
(SELECT 不良数='不良数A',sum(不良数)
FROM sheet1
WHERE 位置 Like '*Q4002*' And 责任='来料'

union

SELECT '不良数B',sum(不良数)
FROM sheet1
WHERE 位置 Like '*Q4003*' And 责任='来料'

union

UNION SELECT '不良数C',sum(不良数)
FROM sheet1
WHERE 位置 Like '*Q4004*' And 责任='来料')t

[cd731107]

insert into sheet(A,B,C) select 
(SELECT sum(不良数) FROM sheet1 WHERE 位置 Like '*Q4002*' And 责任='来料'),
(SELECT sum(不良数) FROM sheet1 WHERE 位置 Like '*Q4003*' And 责任='来料'),
(SELECT sum(不良数) FROM sheet1 WHERE 位置 Like '*Q4004*' And 责任='来料')