跳至主要內容

采购收货单查询

五六零网校小于 1 分钟

代码示例

SELECT T1.[DocNum], T1.DocNum, T1.[CardName], T2.[ItemCode], T2.[Dscription]
	, T2.[Quantity], T0.[U_NAME]
FROM OUSR T0
	INNER JOIN OPDN T1 ON T0.[USERID] = T1.[UserSign]
	INNER JOIN PDN1 T2 ON T1.[DocEntry] = T2.[DocEntry]
WHERE T1.DOCDATE>=[%1] AND T1.DOCDATE<=[%2]