可以用UNION SELECT ID,A1,A2,a3,a4,"" as b1,"" as b2, "" as b3 from a表 union SELECT ID,A1,A2,"" as a3,"" as a4, b1,b2, b3 from B表
