Time : 10:09:39 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and mt.MASTERTRANSACTIONID=' at line 4 Raw SQL : select mt.REFERENCENO,mt.NARRATIONS,mt.AUTOVOUCHERNO,al.NAME,al.ISITPARTY,t.MASTERDRCR,t.TRANSACTIONID,mt.TRANSACTIONDATE,t.subamount,t.INSTRUMENTDATE,t.REFERENCENO as instno,t.NARRATIONS as transnarration from mastertransaction mt inner join transaction t on mt.MASTERTRANSACTIONID=t.MASTERTRANSACTIONID inner join accountledger al on al.ACCOUNTLEDGERID=t.ACCOUNTLEDGERID where ACCOUNTVOUCHERTYPEID= and mt.MASTERTRANSACTIONID=