1.left join on剖析
来源:互联网 发布:男生发型软件app 编辑:程序博客网 时间:2024/04/29 04:03
1.举个例子,就清楚了。两个表tb_userstat_all,tb_userstat_imeiimsi_allaselect * from tb_userstat_all as a left join tb_userstat_imeiimsi_all as b on a.sdate = b.sdate and b.sdate BETWEEN '20151222' and '20151225';bselect * from tb_userstat_all as a left join tb_userstat_imeiimsi_all as b on a.sdate = b.sdate and a.sdate BETWEEN '20151222' and '20151225';cselect * from tb_userstat_all as a left join tb_userstat_imeiimsi_all as b on a.sdate = b.sdate where a.sdate BETWEEN '20151222' and '20151225';dselect * from tb_userstat_all as a left join tb_userstat_imeiimsi_all as b on a.sdate = b.sdate where b.sdate BETWEEN '20151222' and '20151225';
查询结果是:
a:300条记录
b:300条记录
c:2条记录
d:2条记录
结论:
left join on后面的条件对主表不起作用。主表仍然会查询出所有的记录,但是 on 后面的条件 会对从表有影响。
where 后面跟的条件 是将连接查询后的结果 进行筛选。
因此,根据需求灵活的运用 on 还是 where.
1 0
- 1.left join on剖析
- left join on
- sql-left join on
- inner join on, left join on, right join on讲解
- inner join on, left join on, right join on
- inner join on, left join on, right join on讲解
- inner join on, left join on, right join on讲解
- inner join on, left join on, right join on
- nner join on, left join on, right join on讲解
- inner join on, left join on, right join on讲解
- SQL--inner join on, left join on, right join on
- inner join on, left join on, right join on讲解
- inner join on, left join on, right join on对比
- inner join on, left join on, right join on
- inner join on, left join on, right join on讲解
- inner join on, left join on, right join on
- inner join on, left join on, right join on
- inner join on, left join on, right join on
- 彻底明白JavaScript中的标签语句
- JQuery按钮倒计时
- HttpPostedFile类 HttpPostedFile转字节bate
- Android导入外部数据库
- 数据库连接池性能比对
- 1.left join on剖析
- mysql出现错误“ Every derived table must have its own alias”
- Oracle 密码文件
- 记录平时用到的东西
- 手机模拟蓝牙手柄控制kobuki底座
- 将Excel文件导出至DataTable(第一行作为表头)
- 关于应用打开word、pdf
- 转载:JS获取回车事件(兼容各浏览器) 另easyul框架的方式
- Endian