Skip to Content
0
Former Member
May 20, 2010 at 05:36 AM

Query

23 Views

Hi

What is wrong with this query.

SELECT T0.DocNum as 'Order No' , T0.DocDate as 'Date', T0.CardName as 'Vendor Name',T0.DocTotal as 'Invoice Total (Rs.)',T1.DocNum as Invoice No. ,T1.Docdate as Invoice Date,T1.U_Tr_Name

from ORDR T0 Left Join OINV T1 on T0.DocEntry = T1.DocEntry

WHERE T0.DocDate BETWEEN '[%0]' AND '[%1]'

Thanks