Access 2000(MDB基础版). Stametement:
insert into full_join_DR(y,m,ds,rs,b)
select r.y, r.m, d.summa as ds , r.summa as rs , d.summa - r.summa as b
from r left join d on r.y=d.y and r.m=d.m
union
select d.y, d.m, d.summa, r.summa , d.summa - r.summa
from d left join r on r.y=d.y and r.m=d.m
错误:语法错误
尽管内部SELECT语句工作正常