小白先在此谢过了。现在有二个表A,B,两个表中有相同字段ID和QTY
要实现用语句查询显示出来,分开求和QTY,但ID只显示一行。如:A表: ID QTY
1 5
1 10
2 15
3 0
B表: ID QTY
1 10
2 15
2 10
3 8
结果实现: ID QTY(A) QTY(B)
1 15 10
2 15 25
3 0 8
要实现用语句查询显示出来,分开求和QTY,但ID只显示一行。如:A表: ID QTY
1 5
1 10
2 15
3 0
B表: ID QTY
1 10
2 15
2 10
3 8
结果实现: ID QTY(A) QTY(B)
1 15 10
2 15 25
3 0 8
(select id,sum(qty) qty from a group by id) a,
(select id,sum(qty) qty from b group by id) b
where a,id=b.id
FROM (SELECT ID, SUM(QTY) QTY FROM A GROUP BY ID) A,
(SELECT ID, SUM(QTY) QTY FROM B GROUP BY ID) B
WHERE A.ID = B.
from
(select id,sum(qty) qtya from a group by a.id) t1,
(select id,sum(qty) qtya from b group by b.id) t2
where t1.id=t2.id
(select id,sum(qty) qty from a group by id) a,
(select id,sum(qty) qty from b group by id) b
where a,id=b.id
(SELECT A.ID,SUM(A.QTY) FROM A GROUP BY A.ID) 表1,
(SELECT B.ID,SUM(B.QTY) FROM B GROUP BY B.ID) 表2
WHERE 表1.ID=表2.ID