最后两个由于MySQL不支持FULL OUTER JOIN,所以用 UNION 连接。
从左往右第一个:
SELECT * FROM tableA A LEFT JOIN tableB B ON A.key=b.key
UNION
SELECT * FROM tableA A RIGHT JOIN tableB B ON A.key=b.key
第二个:
SELECT * FROM tableA A LEFT JOIN tableB B ON A.key=b.key WHERE B.key IS NULL
UNION
SELECT * FROM tableA A RIGHT JOIN tableB B ON A.key=b.key WHERE A.key IS NULL