> 學習位置：http://www.imooc.com/video/7764
**A表 user1**
| id | name |
| -- | -- |
| 1 | 唐僧 |
| 2 | 豬八戒 |
| 3 | 孫悟空 |
| 4 | 沙僧 |
**B表 user2**
| id | name |
| -- | -- |
| 1 | 孫悟空 |
| 2 | 牛魔王 |
| 3 | 蛟魔王 |
| 4 | 鵬魔王 |
| 5 | 獅駝王 |
## 內鏈接 INNER
> 基于連接謂詞將 A、B的列組合一起，產生新的結果表
~~~
SELECT a.name,a.over,b.over
FROM user1 a
INNER JOIN user2 b
ON a.name = b.name;
~~~
## 全部連接 FULL OUTER
## 左外連接 LEFT OUTER
~~~
SELECT a.name,a.over,b.over
FROM user1 a
LEft JOIN user2 b
ON a.name=b.name;
~~~
~~~
WHERE b.name is not null;
~~~
## 右外連接 RIGHT OUTER
## 交叉連接 CROSS
~~~
SELECT a.name,a.over,b.name.b.over
FROM user1 a
CROSS JOIN user2 b
~~~
> 不需要on
## 優化子查詢
~~~
SELECT a.name,
a.over,
(SELECT over FROM user2 b WHERE a.name = b.name) AS over2
FROM user1 a;
~~~
