急~~~请帮忙

Question

select A.ITEM_CODE,A.LOCATION,A.QUANTITY, B.QUANTITY
from (select ITEM_CODE,LOCATION,SUM(QUANTITY) QUANTITY
         from SMMFMOVZM
           where STATUS=05 
             GROUP BY ITEM_CODE,LOCATION) A 
left join 
(select ITEM_CODE,LOCATION,SUM(QUANTITY) QUANTITY
       from SMMFMOVZM
          GROUP BY ITEM_CODE,LOCATION) B 
on A.ITEM_CODE=B.ITEM_CODE AND A.LOCATION=B.LOCATION

Answer 1

select S1.ITEM_CODE,S1.LOCATION,SUM(S1.QUANTITY),SUM(S2.QUANTITY)
from SMMFMOVZM S1,SMMFMOVZM S2
where S1.STATUS=05 AND S1.MVMNT_REF=S2.MVMNT_REF AND S1.MVMNT_LINE=S2.MVMNT_LINE
GROUP BY S1.ITEM_CODE,S1.LOCATION having SUM(S1.QUANTITY)=SUM(S2.QUANTITY)

Answer 2

select * from 
(select ITEM_CODE,LOCATION,SUM(QUANTITY)
from SMMFMOVZM
where STATUS=05 
GROUP BY ITEM_CODE,LOCATION)a,
(select ITEM_CODE,LOCATION,SUM(QUANTITY)
from SMMFMOVZM
GROUP BY ITEM_CODE,LOCATION)b
where a.item_code=b.item_code

Answer 3

select S1.ITEM_CODE,S1.LOCATION,S1.QUANTITY as sum1,S2.QUANTITY as sum2
from (
select ITEM_CODE,LOCATION,SUM(QUANTITY) as QUANTITY
from SMMFMOVZM
where STATUS=05 
GROUP BY ITEM_CODE,LOCATION
) as s1,(
select ITEM_CODE,LOCATION,SUM(QUANTITY) as QUANTITY
from SMMFMOVZM
GROUP BY ITEM_CODE,LOCATION
) as s2
where s.ITEM_CODE=s2.ITEM_CODE
and s1.LOCATION=s2.LOCATION

Answer 4

谢谢楼上诸位
但我的S1.MVMNT_REF=S2.MVMNT_REF AND S1.MVMNT_LINE=S2.MVMNT_LINE才是主键s1.ITEM_CODE=s2.ITEM_CODE and s1.LOCATION=s2.LOCATION 不是主键