Time : 11:36:51 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 NAME='Shari Mahavir Spares'' at line 1 Raw SQL : select NAME,CITY,PARTYID from partydetail,contact where PARTYID=PARTY and CITY= and NAME='Shari Mahavir Spares'