送货单记录查询

代码示例

SELECT T0.[Docentry] AS '送货单号', T0.[TaxDate], T0.[CardCode], T0.[CardName], T1.[ItemCode]
	, T1.[Dscription], T1.[Quantity]
FROM ODLN T0
	INNER JOIN DLN1 T1 ON T0.[DocEntry] = T1.[DocEntry]
WHERE T0.[TaxDate] >= [%0]
	AND T0.[TaxDate] <= [%1]
ORDER BY T0.[DocNum] DESC