22,209
社区成员
发帖
与我相关
我的任务
分享
select RdRecords.cSOCode as 销售订单号,RdRecord.cCode as 单据号,RdRecord.dDate as 入库日期,RdRecords.cInvCode as 存货编码,
RdRecords.iQuantity as 数量,linshi.单价,linshi.不含佣金单价,SO_SOMain.cCusCode as 客户编码,SO_SOMain.cexch_name as 币种
from RdRecords inner join (select cSOCode as 销售订单号1,cInvCode as 存货编码1,max(iUnitPrice) as 单价,max(cDefine27) as
不含佣金单价 from SO_SODetails group by cSOCode,cInvCode) as linshi on RdRecords.cSOCode = linshi.销售订单号1 and
RdRecords.cInvCode = linshi.存货编码1 inner join RdRecord on RdRecords.ID = RdRecord.ID inner join SO_SOMain on
RdRecords.cSOCode = SO_SOMain.cSOCode
SELECT RdRecords.cSOCode AS 销售订单号 ,
RdRecord.cCode AS 单据号 ,
RdRecord.dDate AS 入库日期 ,
RdRecords.cInvCode AS 存货编码 ,
RdRecords.iQuantity AS 数量 ,
linshi.单价 ,
linshi.不含佣金单价 ,
SO_SOMain.cCusCode AS 客户编码 ,
SO_SOMain.cexch_name AS 币种
FROM RdRecords
INNER JOIN ( SELECT cSOCode AS 销售订单号1 ,
cInvCode AS 存货编码1 ,
MAX(iUnitPrice) AS 单价 ,
MAX(cDefine27) AS 不含佣金单价
FROM SO_SODetails
GROUP BY cSOCode ,
cInvCode
) AS linshi ON RdRecords.cSOCode = linshi.销售订单号1
AND RdRecords.cInvCode = linshi.存货编码1
INNER JOIN RdRecord ON RdRecords.ID = RdRecord.ID
INNER JOIN SO_SOMain ON RdRecords.cSOCode = SO_SOMain.cSOCode;