mysql 的查詢嵌套有關問題

mysql 的查詢嵌套問題。

SQL code

select 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 code

SELECT 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
