以上的sql语句如下:
SELECT A.ID,A.FactoryBatchNo,B.Orderdate,B.OrderClient,SUM(C.ProdNum),
SUM(C.ProdNum)-SUM(DISTINCT D.ProdNum)
FROM FACTORY_ORDER_BATCH A,FACTORY_ORDER_INFO B,
FACTORY_ORDER_PRODUCT C,FACTORY_ORDER_STATUS D
WHERE A.ID=B.BatchId AND B.ID=C.OrderId AND B.ID=D.OrderId AND A.DoneFlg='1'
GROUP BY A.FactoryBatchNo,B.Orderdate,B.OrderClient,A.ID
有什么办法替换DISTINCT也可以!!!
SELECT A.ID,A.FactoryBatchNo,B.Orderdate,B.OrderClient,SUM(C.ProdNum),
SUM(C.ProdNum)-SUM(DISTINCT D.ProdNum)
FROM FACTORY_ORDER_BATCH A,FACTORY_ORDER_INFO B,
FACTORY_ORDER_PRODUCT C,FACTORY_ORDER_STATUS D
WHERE A.ID=B.BatchId AND B.ID=C.OrderId AND B.ID=D.OrderId AND A.DoneFlg='1'
GROUP BY A.FactoryBatchNo,B.Orderdate,B.OrderClient,A.ID
有什么办法替换DISTINCT也可以!!!
A_A_A(黄蜂):怎么直接用SQL