首页 > 后端开发 > php教程 > mysql 的查询嵌套有关问题

mysql 的查询嵌套有关问题

WBOY
发布: 2016-06-13 10:32:26
原创
873 人浏览过

mysql 的查询嵌套问题。

SQL code
<!--Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->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<div class="clear">
                 
              
              
        
            </div>
登录后复制
相关标签:
来源:php.cn
本站声明
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系admin@php.cn
热门教程
更多>
最新下载
更多>
网站特效
网站源码
网站素材
前端模板