FULL OUTER JOIN 关键字只要左表(table1)和右表(table2)其中一个表中存在匹配,则返回行.
FULL OUTER JOIN 关键字结合了 LEFT JOIN 和 RIGHT JOIN 的结果。
### SQL FULL OUTER JOIN 语法
SELECT*column\_name(s)*
FROM*table1*
FULL OUTER JOIN*table2*
ON*table1.column\_name*\=*table2.column\_name*;
![SQL FULL OUTER JOIN](https://www.runoob.com/wp-content/uploads/2013/09/img_fulljoin.gif)