# `INNER JOIN`
__*INNER JOIN*__
```
tidb> SELECT a.name, b.name FROM test.a a ~!@JOIN@!~ test.b b ON a.id=b.id;
+------+------+
| name | name |
+------+------+
| AA   | BA   |
| AB   | BB   |
| AC   | BC   |
+------+------+

tidb> SELECT a.name, c.name FROM test.a a ~!@JOIN@!~ test.c c ON a.id=c.id;
+------+------+
| name | name |
+------+------+
| AA   | CA   |
| AB   | CB   |
+------+------+

tidb> SELECT a.name, d.name FROM test.a a ~!@JOIN@!~ test.d d ON a.id=d.id;
+------+------+
| name | name |
+------+------+
| AA   | DA   |
| AB   | DB   |
+------+------+
```

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