其中测试:SELECT SUM(B.QTY) FROM WORKP A,WORKC B WHERE A.ID=B.ID
AND TO_CHAR(A.DTIME,'YYYY')='2005'
AND TO_CHAR(A.DTIME,'MM')='03' 此语句没有出错,有记录。
AND TO_CHAR(A.DTIME,'YYYY')='2005'
AND TO_CHAR(A.DTIME,'MM')='03' 此语句没有出错,有记录。
AND TO_CHAR(A.DTIME,'YYYY')='2005'
AND TO_CHAR(A.DTIME,'MM')='03' 此语句没有出错,有记录。
WHERE A.ID=B.ID
AND TO_CHAR(A.DTIME,'YYYY')='2005'
AND TO_CHAR(A.DTIME,'MM')='03' AND A.DID=C.DID)
group by c.did,c.dname
FROM WORKP A, WORKC B, MEMBER C
WHERE A.ID = B.ID
AND A.DID = C.DID
AND TO_CHAR(A.DTIME, 'YYYY-MM') = '2005-03')
GROUP BY C.DID, B.ID
(SELECT SUM(B.QTY) QTY,A.DID DID FROM WORKP A,WORKC B WHERE A.ID=B.ID
AND TO_CHAR(A.DTIME,'YYYY')='2005'
AND TO_CHAR(A.DTIME,'MM')='03') D,MEMBER C
WHERE D.DID=C.DID
SELECT C.DID,C.DNAME,D.QTY FROM
(SELECT SUM(B.QTY) QTY,A.DID DID FROM WORKP A,WORKC B WHERE A.ID=B.ID
AND TO_CHAR(A.DTIME,'YYYY')='2005'
AND TO_CHAR(A.DTIME,'MM')='03' GROUP BY DID) D,MEMBER C
WHERE D.DID=C.DID