sql codeselect a.*, d.sell_countfrom borough as a left join ( select da.* from ( select count(db.id) as sell_count,db.borough_id from housesell as db where db.borough_id = a.id ) as da ) as dwhere a.is_checked = 1 order by id desc limit 0, 10
请问，left join 里面的
where db.borough_id = a.id 这一句会报错。请问大家有什么方式来实现嘛。
------解决方案--------------------
把order by a.id 改成group by
sql codeselect a.*, count(db.id) as sell_count from borough as a left join housesell as db on( db.borough_id = a.id)where a.is_checked = 1 group by a.idorder by id desc limit 0, 10