mysql left join,right join,inner join用法举例
来源:互联网 发布:lumia 813刷linux 编辑:程序博客网 时间:2024/05/17 06:09
现有A和B两个表
表A记录如下:
aID aNum
1 a20050111
2 a20050112
3 a20050113
4 a20050114
5 a20050115
表B记录如下:
bID bName
1 2006032401
2 2006032402
3 2006032403
4 2006032404
8 2006032408
1.left join(左联接)
SELECT * FROM a LEFT JOIN b ON a.aID =b.bID
结果如下:
aID aNum bID bName
1 a20050111 1 2006032401
2 a20050112 2 2006032402
3 a20050113 3 2006032403
4 a20050114 4 2006032404
5 a20050115 NULL NULL
(所影响的行数为 5 行)
结果说明:
left join是以A表的记录为基础的,A可以看成左表,B可以看成右表,left join是以左表为准的.
换句话说,左表(A)的记录将会全部表示出来,而右表(B)只会显示符合搜索条件的记录(例子中为: A.aID = B.bID). B表记录不足的地方均为NULL.
2.right join(右联接)
SELECT * FROM a RIGHT JOING b ON a.aID = b.bID
结果如下:
aID aNum bID bName
1 a20050111 1 2006032401
2 a20050112 2 2006032402
3 a20050113 3 2006032403
4 a20050114 4 2006032404
NULL NULL 8 2006032408
(所影响的行数为 5 行)
结果说明:
仔细观察一下,就会发现,和left join的结果刚好相反,这次是以右表(B)为基础的,A表不足的地方用NULL填充.
3.inner join(相等联接或内联接)
SELECT * FROM a INNER JOIN b ON a.aID =b.bID
等同于以下SQL句:
SELECT * FROM a,b WHERE a.aID = b.bID
结果如下:
aID aNum bID bName
1 a20050111 1 2006032401
2 a20050112 2 2006032402
3 a20050113 3 2006032403
4 a20050114 4 2006032404
结果说明:
很明显,这里只显示出了 A.aID = B.bID的记录.这说明inner join并不以谁为基础,它只显示符合条件的记录.
- mysql left join,right join,inner join用法举例
- mysql left join,right join ,cross join inner join 用法
- Left join , Right Join, Inner Join 用法
- mysql left join,right join,inner join用法分析
- mysql left join,right join,inner join用法分析
- mysql left join,right join,inner join用法分析
- 简单记录mysql left join,right join,inner join用法
- mysql left join,right join,inner join用法分析
- mysql中left join,right join,inner join用法
- mysql left join,right join,inner join用法分析
- mysql的left join,right join,inner join用法分析
- mysql left join,right join,inner join用法分析
- mysql left join,right join,inner join用法分析
- mysql left join,right join,inner join用法分析
- mysql中left join right join inner join用法
- mysql left join right join inner join
- mysql left join,right join,inner join
- Mysql-left join,right join,inner join
- java读取word-excel-ppt文件
- 更改外购入库单的不一致辞价格
- 缺点
- ACE的MFC库的编译
- Linux Windows MySQL 更改MySQL数据库目录的位置
- mysql left join,right join,inner join用法举例
- 众核技术报告会归来
- 统计软件全家福
- 异构并行
- 摘要的写法
- Openbsd 下面 mysql 报错socket '/var/run/mysql/mysql.sock
- Zappos:一个神话般的在线零售商
- 绪论的写法
- [SEO工具]收集整理的SEO工具,站长们必备良具!!