如果是Access,不支持full join,变通处理
select * from A left join B on A.id=B.idunion all select * from A right join B on A.id=B.id