Aseem Bhardwaj

Aseem Bhardwaj

  • 1.3k
  • 114
  • 20.6k

getting error of <

Sep 30 2016 4:43 AM
SELECT Gledger.*,
CAST('' AS DECIMAL(5,0)) as sno ,
00000000000000.00 AS BALANCE ,
SPACE(5) AS DC ,
ISNULL(master.ma_AcName,'') as ma_AcName,
master.PK_ID
FROM Gledger LEFT JOIN master ON
Gledger.Gl_AcId = master.pk_id
WHERE gledger.Gl_AcId = <<THISFORM.ACID>>
and Gledger.Gl_Date between '<<m.lsdate>>' and '<<m.ledate>>'
and LEFT(Gledger.gl_voucher,2) <<m.ltyPe>>
and <<IIF(thisform.container1.check1.Value,'gledger.gl_voucher != "O"','1=1')>>
ORDER BY gledger.gl_date
 
this is my query please help and give me optimal solution. 

Answers (6)