mysql left join和union结合的用法
来源:互联网 发布:linux 卸载ant 编辑:程序博客网 时间:2024/05/18 04:23
left join和union结合的用法子查询union 然后加个括号设置个别名 (union自动去除 重复的 )select o.nickName,o.sex,o.province,o.city,from_unixtime(m.time,'%Y-%m-%d %H:%i:%s') as starttime,from_unixtime(z.time,'%Y-%m-%d %H:%i:%s') as endtime,ROUND((z.time-m.time)/60) as haoshifenzhong,from_unixtime(z1.time,'%Y-%m-%d') as choujiangtime from (select openid,time from xintjiashen_zhongjiang2 union select openid,time from xintjiashen_meizhong2) as z left join xintjiashen_my as m on z.openid=m.openid left join xintjiashen_zhongjiang1 as z1 on m.openid=z1.openid left join xintjiashen_oauthinfo as o on m.openid=o.wechatId where z1.prize_id !=8
查看原文:http://newmiracle.cn/?p=1680
阅读全文
0 0
- mysql left join和union结合的用法
- MySQL:union、left join
- union和left join的应用区别
- MySQL的学习--join和union的用法
- Mysql----Join用法(Inner join,Left join,Right join, Cross join, Union模拟Full join)及---性能优化
- mysql的left join 和 right join
- sql之left join、right join、inner join的区别 union和union all
- mysql的left join,right join,inner join用法分析
- [MySql]多表联查:join、left join、right join的用法
- SQL Left Join和Union Join
- mysql 语句 union ,union all left join,right join
- mysql的left join、right join、inner join、union等连接查询
- MySQL JOIN (inner 和 left 的区别)
- MySQL中Left Join用法
- mysql中left join,right join,inner join,outer join的用法详解【转】
- mysql中left join,right join,inner join,outer join的用法详解
- MySql中inner join和left join的特殊情况
- mysql join 和left join 对于索引的问题
- IntelliJ IDEA:tomcat和jetty配置
- vue-cli脚手架搭建webpack+vue项目
- 数据库和缓存服务器的特性与功能
- Mac下面visio的替代品Omnigraffle,很好用
- 深入浅出RxJava三--响应式的好处
- mysql left join和union结合的用法
- NPOI数据导入导出帮助管理类
- simpledateformat 字符串转时间
- studio编译错误Error:Failed to open zip file. Gradle's dependency cache may be corrupt
- 进程render要读取一个scene.dat文件过程(normal and mmap)
- Python简单处理图片
- 10道Struts2面试题
- Spring事务异常回滚,捕获异常不抛出就不会回滚
- 测试主管如何规范公司的测试流程?