首页 > 其他 > 详细

把查询到结果合并放在一行 JOIN非union

时间:2016-01-08 23:18:13      阅读:207      评论:0      收藏:0      [点我收藏+]
select one.max,one.min,one.low sts,c.high ens,one.time from (

        select a.max max,a.min min,b.low low,a.time time,a.aid aid from

        (select max(price) max,min(price) min,time time,id aid from on_jiaoyi_into where sid=".$id."
        group by DATE_FORMAT(`time`,%Y-%m-%d) ) a LEFT JOIN

        (select price low,id bid from on_jiaoyi_into where sid=".$id."
        group by DATE_FORMAT(`time`,%Y-%m-%d)  
        order by time ) b on a.aid=b.bid 

        ) one LEFT JOIN

        (select price high,id cid from on_jiaoyi_into where sid=".$id."
        group by DATE_FORMAT(`time`,%Y-%m-%d)  
        order by time desc) c on one.aid=c.cid 

 

把查询到结果合并放在一行 JOIN非union

原文:http://www.cnblogs.com/hellowzd/p/5114997.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!