SELECT bizid AS bid, bizid, biz_name, biz_cid, biz_photo, biz_intro, (SELECT COUNT(*) FROM kacol_bizuser WHERE bizid=bid and want=1) AS count FROM kacol_bizinfo ORDER BY count DESC在 mysql5.0 下正常 在mysql 4.0 下就不可以
调试欢乐多
你那个语句可以改为
left join 方法SELECT i.*,count(u.*) as countFROM kacol_bizinfo as i left join kacol_bizuser as u on u.bizid=bid and u.want=1
ORDER BY count DESC
count(u.*) as count
这里一加上去就出问题
SELECT i.*,count(u.*) as `count`FROM kacol_bizinfo as i left join kacol_bizuser as u on u.bizid=bid and u.want=1ORDER BY count DESC