Home >Backend Development >PHP Tutorial > mysql 的查询嵌套有关问题
mysql 的查询嵌套问题。
<!-- Code highlighting produced by Actipro CodeHighlighter (freeware) http://www.CodeHighlighter.com/ --> select a.*, d.sell_count from 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 d where a.is_checked = 1 order by id desc LIMIT 0, 10
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.id ORDER BY id DESC LIMIT 0, 10 <div class="clear"> </div>