SELECT /*+INDEX(D PK_STOCKDAY)*/ G.GDSNAME, G.GDSID, G.GDSINID, G.SPECIFY,
G.UOMID,G.SalePrice,0 as QTY,SUM(D.ADDQTY) AS PROFQTY
FROM GOODS G,STOCKDAY D
WHERE ( G.ACCOUNTID = :LS_ACCOUNTID )
AND ( G.GDSID like :LS_GDSID )
AND ( D.GDSINID(+) = G.GDSINID)
AND ( D.STOCKLOCID(+) =:LS_STOCKLOCID )
AND ( D.ACCOUNTID(+) = :LS_ACCOUNTID1 )
AND ( D.CUSTOMERID(+) = :LS_CUSTOMERID)
AND ( D.DAY(+) <= :LS_BILLDT)
GROUP BY G.GDSNAME,G.GDSID,G.GDSINID,G.SPECIFY,G.UOMID,G.SalePrice;
我试过很多遍,在ACCESS中,有试成:
SELECT /*+INDEX(D PK_STOCKDAY)*/ G.GDSNAME, G.GDSID, G.GDSINID, G.SPECIFY,G.UOMID,G.SalePrice,0 as QTY,SUM(D.ADDQTY) AS PROFQTY
FROM GOODS G
LEFT JOIN STOCKDAY D ON ( D.GDSINID = G.GDSINID)
AND ( D.STOCKLOCID =:LS_STOCKLOCID )
//但这里不允许联接一个常量,非要是一个字段名才行
AND ( D.ACCOUNTID = :LS_ACCOUNTID1 )
AND ( D.CUSTOMERID = :LS_CUSTOMERID)
AND ( D.DAY <= :LS_BILLDT)
WHERE ( G.ACCOUNTID = :LS_ACCOUNTID )
AND ( G.GDSID like :LS_GDSID )
GROUP BY G.GDSNAME,G.GDSID,G.GDSINID,G.SPECIFY,G.UOMID,G.SalePrice;
不知道哪位可以帮帮我?