今天用MySQL进行全联查询时报错了,才知道MySQL不支持FULL JOIN,只支持左右关联
可根据左右关联查询实现全联查询
左联—— LEFT JOIN
SELECT * FROM test_table1 a LEFT JOIN test_table2 b ON a.id=b.id
右联—— RIGHT JOIN
SELECT * FROM test_table1 a RIGHT JOIN test_table2 b ON a.id=b.id
全联查询
SELECT * FROM (
( SELECT a.*, b.id AS b_id,b.name AS b_name FROM test_table1 a
LEFT JOIN test_table2 b ON a.id=b.id
)
UNION
( SELECT a.*, b.id AS b_id,b.name AS b_name FROM test_table1 a
RIGHT JOIN test_table2 b ON a.id=b.id
)
) c