FULL OUTER JOINMysqL中没有。见7.2.12。外连接简化和12.2.8.1。JOIN语法：
您可以FULL OUTER JOIN使用UNION（从MysqL 4.0.0开始）进行仿真：
有两个表t1，t2：
SELECT * FROM t1
LEFT JOIN t2 ON t1.id = t2.id
UNION
SELECT * FROM t1
RIGHT JOIN t2 ON t1.id = t2.id
有三个表t1，t2，t3：
SELECT * FROM t1
LEFT JOIN t2 ON t1.id = t2.id
LEFT JOIN t3 ON t2.id = t3.id
UNION
SELECT * FROM t1
RIGHT JOIN t2 ON t1.id = t2.id
LEFT JOIN t3 ON t2.id = t3.id
UNION
SELECT * FROM t1
RIGHT JOIN t2 ON t1.id = t2.id
RIGHT JOIN t3 ON t2.id = t3.id
602392714
清零编程群