Skip to Content
0
Former Member
Aug 26, 2009 at 09:39 PM

Query Help

36 Views

I have the following Query and I am tryibg to add from OITW 'OnHand', 'IsCommitted', 'OnOrder'.

SELECT T1.DocNum AS 'Order #', T1.DocDueDate AS 'Cancel', T1.TaxDate AS 'Start', T1.CardName AS 'Name', T0.ItemCode AS 'Item #', T0.Dscription AS 'Desc.', T0.OpenCreQty AS 'Qty' FROM [dbo].[RDR1] T0 INNER JOIN [dbo].[ORDR] T1 ON T1.DocEntry = T0.DocEntry WHERE (T0.OpenCreQty > 0 ) ORDER BY T1.DocDueDate