Question

关于access 多表根据条件查询的问题

条件：
A表：

B表：

结果：
通过按照ID条件来查询得到C表的结果：

请各位高手帮忙啦！！由于两个表的结构不一致，所以用Union 弄不好。
感谢！！





Answer 1

可以用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表