# Cartesian Product
__*Cartesian Product*__
+ The **`JOIN`** keyword is used, but there are no conditions for **`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)
```

------------------------------------------------------------