mysql 的查询嵌套问题。
- SQL code
<!---ecms Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->select a.*, d.sell_countfrom borough as a left join ( select da.* from ( selec<span style="color:transparent">~来1源gaodai#ma#com搞*代#码1网</span><abbr>搞代gaodaima码</abbr>t 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搞代码网（gaodaima.com）提供的所有资源部分来自互联网，如果有侵犯您的版权或其他权益，请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected]，我们会在看到邮件的第一时间内为您处理，或直接联系QQ：872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接：mysql 的查询嵌套有关问题
