#  `OUTER JOIN`

__*OUTER JOIN*__

+ 左右外联:

```11
tidb> select a.name, c.name from test.a a ~!@LEFT JOIN@!~ test.c c on a.id=c.id;
+------+------+
| name | name |
+------+------+
| AA   | CA   |
| AB   | CB   |
| AC   | ~!@NULL@!~ |
+------+------+
tidb> select a.name, c.name from test.a a ~!@RIGHT JOIN@!~ test.c c on a.id=c.id;
+------+------+
| name | name |
+------+------+
| AA   | CA   |
| AB   | CB   |
| ~!@NULL@!~ | CC   |
+------+------+
```
------------------------------------------------------------------