select nvl(表1.xm,表2.xm) xm,nvl(表1.sfz,表2.sfz) sfz,;
iif(empty(qiandao1),"否",iif(isnull(qiandao1),"无此人","是"))+space(8) qiandao1,;
iif(empty(qiandao2),"否",iif(isnull(qiandao2),"无此人","是"))+space(8) qiandao2 from 表1 full join 表2 on 表1.sfz=表2.sfz
Select Nvl(A2.学校, A1.学校) as 学校 ;
,Nvl(A2.姓名, A1.姓名) as 姓名 ;
,Nvl(A2.身份证, A1.身份证) as 身份证 ;
,Nvl(A2.签到1, '无') as 签到1 ;
,Nvl(A2.签到2, A1.签到2) as 签到2 ;
from A2 full join A1 on A2.姓名 == A1.姓名 ;
into dbf 新表