mysql多表联合查询

Question

MySQL数据库，Python开发，怎么写sql才能将表1和表2已结果的形式返回

Answer 1

SELECT IFNULL(a,a1) a,b,c FROM 
(

SELECT test1.a,test1.b,test2.a AS a1, test2.c FROM test1 LEFT JOIN test2 ON test1.a = test2.a
UNION 
SELECT test1.a,test1.b,test2.a AS a1, test2.c FROM test1 RIGHT  JOIN test2 ON test1.a = test2.a

) AS ALL_

或

SELECT a,GROUP_CONCAT(b) b, GROUP_CONCAT(c) c FROM 

(

SELECT a,b,null as c FROM test1 
UNION ALL
SELECT a,null as b, c FROM test2

) AS ALL_


GROUP BY a