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.tblfile1' doesn't exist Select count(distinct familyid) from tblfile1
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 10 select count(tblfile1.familyid) as count1,tblfamily.familyid,tblfamily.familycode,tblfamily.fathername,
tblfamily.headname, tblfamily.totalfamilymember,tblfamily.totscore,tblfamily.landtypeid,tblfamily.socialgroup,
tblfamily.villagecode, tblsocialstatus.socialdescinenglish,tblfamilyhindi.headinhindi,tblfamilyhindi.fatherinhindi,tblincome.incomeinenglish,tblfamily.verificationstatus from tblfile1
left join tblfamily on tblfamily.familyid=tblfile1.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 tblincome on tblincome.incomecodeid = tblfamily.incomecodeid
where (tblfamily.villagecode = '501010010004')
group by tblfile1.familyid Limit 0,
Web Based Project Management System