销售交货单明细表

五六零网校小于 1 分钟

示例代码

SELECT T0.[DocNum], T0.[CardName], T0.[NumAtCard], T0.[DocDueDate] AS '交货日期', T1.[ItemCode]
	, T1.[Dscription], T1.[Quantity], T0.[Comments]
FROM ODLN T0
	INNER JOIN DLN1 T1 ON T0.[DocEntry] = T1.[DocEntry]
WHERE (T0.[CardName] = '[%0]'
		OR '[%0]' = '')
	AND T0.[DocDate] >= [%1]
	AND T0.[DocDate] <= [%2]
ORDER BY T0.[DocNum] DESC