MySQL Query : SELECT COUNT(*) as count FROM (SELECT * FROM v9_yp_company a, v9_yp_relation b where a.userid=b.userid and a.status=1 and companyname like '%%' order by a.regtime desc) T MySQL Error : Table 'hometexjoin.v9_yp_company' doesn't exist MySQL Errno : 1146 Message : Table 'hometexjoin.v9_yp_company' doesn't exist Need Help?