出入库流水帐的SQL语句怎么写

fsun

如果自己想用自定义报表功能写个出入库流水帐，SQL语句到底该怎么写

sidhkvlin

可以通过事件探查器查询下看系统是怎么写的

fsun

几十个用户在操作。。。。探测到的东西太多

wanyaxiong

我之前有写过这样一个查询语句，不知道跟楼主要的是否一致：
Select RD.cBusType as 业务类型,RD.cSource as 单据来源,RD.cBusCode as 对应业务单号,
RD.cWhCode as 仓库编码,RD.dDate as 单据日期, RD.cCode as 收发单据号,RD.cRdCode as 收发类别编码,
RD.cDepCode as 部门编码 ,RD.cPTCode as 采购类型编码,RD.cSTCode as 销售类型编码 ,RD.cCusCode as 客户编码,
RD.cVenCode as 供应商编码,RD.cOrderCode as 采购订单号,RD.cARVCode as 采购到货单号,RD.cDLCode as 发货退货单主表标识,
RD.cProBatch as 生产批号,RD.cDefine10 as 部门,
RS.cInvCode as 存货编码,IY.cInvName as 存货名称,RS.iQuantity as 数量 ,RS.cBVencode as 供应商编码
from RdRecord RD
Inner Join RdRecords RS On RD.ID=RS.ID
Inner Join Inventory IY On RS.cInvCode=IY.cInvcode

Where RD.dDate>'' and RD.dDate<''
Order by RD.dDate

lg0219

SELECT RdRecord.cCode, RdRecord.dDate, RdRecord.cBusCode, RdRecord.cWhCode,
      RdRecords.cInvCode, RdRecords.iQuantity, RdRecords.iUnitCost, RdRecords.iPrice,
      RdRecord.cBusType
FROM RdRecord INNER JOIN
      RdRecords ON RdRecord.ID = RdRecords.ID

--下面的条件只查询调拨至喷涂仓库的记录
WHERE (RdRecord.cBusType = N'调拨入库') AND (RdRecord.cWhCode = N'07')

penghuanqi

搞这么深奥，实在看不懂呀

LANGJI-TIANYA02

学习了/////////////