# 笛卡尔积

__*笛卡尔积*__

+ 使用了 JOIN 关键字, 但是没有 JOIN 的条件
```
tidb> SELECT a.name, b.name FROM test.a a JOIN test.b b;
+------+------+
| name | name |
+------+------+
| AA   | BC   |
| AA   | BB   |
| AA   | BA   |
| AB   | BC   |
| AB   | BB   |
| AB   | BA   |
| AC   | BC   |
| AC   | BB   |
| AC   | BA   |
+------+------+
9 rows in set (0.01 sec)
```
----------------------------------