select A.字段1,(sum(A.字段2)-sum(B.字段2)) as 数量 from A a,B B WHERE B.字段1 =A.字段1 group by A.字段1 HAVING (sum(A.字段2)-sum(B.字段2))<>0
select A.字段1,(sum(A.字段2)-(select sum(B.字段2) from B where B.字段1 =A.字段1))as 数量 from A where (sum(A.字段2)- (select sum(B.字段2) from B where B.字段1 =A.字段1)<>0 group by A.字段1
from A a,B B
WHERE B.字段1 =A.字段1
group by A.字段1
HAVING (sum(A.字段2)-sum(B.字段2))<>0
from B
where B.字段1 =A.字段1))as 数量
from A where (sum(A.字段2)-
(select sum(B.字段2) from B where B.字段1 =A.字段1)<>0
group by A.字段1