DataBase error - Table 'iay.tblvillages' doesn't exist select villagecode, villages from tblvillages where isactive = 'Yes' order by villagesDataBase error - Table 'iay.tblsettingvalue' doesn't exist select tblsettingvalue.settingvalue from tblsettingvalue
left join tblsetting on tblsettingvalue.settingid = tblsetting.settingid
where tblsetting.parameter = 'frontend_pagelength' DataBase error - Table 'iay.tblfamily' doesn't exist Select count(*) from tblfamily where (tblfamily.villagecode = '501010010004') and tblfamily.totscore='9' and tblfamily.socialgroup in('1','2')DataBase error - 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 '' at line 15 select distinct familycode,tblfile1.familyid as count ,tblfamily.familyid, fathername, headname,totalfamilymember,totscore, tblfamily.landtypeid, tblfamily.socialgroup, tblfamily.villagecode, tblsocialstatus.socialdescinenglish, tblfamilyhindi.headinhindi,tblfamilyhindi.fatherinhindi, tbllandtype.landdescinenglish, tblincome.incomeinenglish from tblfamily
left join tblfile1 on tblfile1.familyid = tblfamily.familyid
left join tblfamilyhindi on tblfamilyhindi.familyhindiid = tblfamily.familyhindiid
left join tblvillages on tblvillages.villagecode = tblfamily.villagecode
left join tblsocialstatus on tblsocialstatus.socialgroup = tblfamily.socialgroup
left join tbllandtype on tbllandtype.landtypeid = tblfamily.landtypeid
left join tblincome on tblincome.incomecodeid = tblfamily.incomecodeid
where (tblfamily.villagecode = '501010010004') and tblfamily.totscore='9' and tblfamily.socialgroup in('1','2') Limit 0,
Web Based Project Management System