select T1.序号,T1.时间,T1.姓名,T1.单位,T1.性别,iif(right(T1.项目,2)='团体','团体项目','个人项目') as 项目,T1.比赛名称,T1.地点 ,T2.大行政区 from [sheet1$] T1,[sheet2$] T2 where T1.单位=T2.单位
select T1.序号,T1.时间,T1.姓名,T1.单位,T1.性别,iif(right(T1.项目,2)='团体','团体项目','个人项目') as 项目,T1.比赛名称,T1.地点 ,T2.大行政区 from [sheet1$] T1,[sheet2$] T2 where T1.单位=T2.单位