----------这个sql 用在你的存储过程。SELECT SY_ORDER_FILE.Line_No, SY_ORDER_FILE.PONo AS KitPONO, SY_ORDER_FILE.PartNo AS KitNo, SY_ORDER_FILE.QTY AS KitQTY, PriceMaster.KitID, SY_ORDER_FILE.PONo AS PartPONo, KitMaster.PartNo, SY_ORDER_FILE.QTY * KitMaster.QTY AS partQTY, SY_ORDER_FILE.FOBDate, MAX(SY_ORDER_FILE.Line_No) AS MaxLine_No FROM SY_ORDER_FILE,PriceMaster,KitMaster WHERE (SY_ORDER_FILE.ComputerName = 'chengxu_pc' ) AND (SY_ORDER_FILE.Transactiontype = 'SF') AND (PriceMaster.KitID IS NOT NULL) and (PriceMaster.KitID = KitMaster.KitID ) and SY_ORDER_FILE.PartNo = PriceMaster.PartNo AND SY_ORDER_FILE.Customer = PriceMaster.Seller AND CAST(SY_ORDER_FILE.FOBDate as datetime)BETWEEN cast(PriceMaster.CutIn_From as datetime) AND cast(PriceMaster.CutIn_To as datetime) GROUP BY SY_ORDER_FILE.Line_No, SY_ORDER_FILE.PONo, SY_ORDER_FILE.QTY, PriceMaster.KitID, KitMaster.PartNo, SY_ORDER_FILE.FOBDate, SY_ORDER_FILE.PartNo, SY_ORDER_FILE.QTY * KitMaster.QTY 说明:SY_ORDER_FILE 这些名称 另起别名也可以,不起名字也可以,
PriceMaster.KitID, SY_ORDER_FILE.PONo AS PartPONo, KitMaster.PartNo, SY_ORDER_FILE.QTY * KitMaster.QTY AS partQTY,
SY_ORDER_FILE.FOBDate, MAX(SY_ORDER_FILE.Line_No) AS MaxLine_No
FROM SY_ORDER_FILE,PriceMaster,KitMaster
WHERE (SY_ORDER_FILE.ComputerName = 'chengxu_pc' ) AND
(SY_ORDER_FILE.Transactiontype = 'SF') AND (PriceMaster.KitID IS NOT NULL)
and (PriceMaster.KitID = KitMaster.KitID )
and SY_ORDER_FILE.PartNo = PriceMaster.PartNo
AND SY_ORDER_FILE.Customer = PriceMaster.Seller
AND CAST(SY_ORDER_FILE.FOBDate as datetime)BETWEEN cast(PriceMaster.CutIn_From as datetime)
AND cast(PriceMaster.CutIn_To as datetime)
GROUP BY SY_ORDER_FILE.Line_No, SY_ORDER_FILE.PONo, SY_ORDER_FILE.QTY, PriceMaster.KitID, KitMaster.PartNo, SY_ORDER_FILE.FOBDate, SY_ORDER_FILE.PartNo,
SY_ORDER_FILE.QTY * KitMaster.QTY
说明:SY_ORDER_FILE 这些名称 另起别名也可以,不起名字也可以,
看来我要重头学起了