用楼上的应该就可以了或换个角度:select name into #T from t1 inset into #t1 select name from t2select a.name,isnull(b.F1,'') F1,isnull(c.F2,'') F2 from #T a,t1 c,t2 c where a.name*=b.name and a.name*=c.name drop table #t
一楼写的没错,但如果对于Access数据库语法就不支持了,不知对这种数据库有没有什么解决办法。
select name=isnull(t1.name,t2.name),f1=isnull(t1.f1,''),f2=isnull(t2.f2,'') from t1 full join t2 on t1.name=t2.name
inset into #t1 select name from t2select a.name,isnull(b.F1,'') F1,isnull(c.F2,'') F2 from #T a,t1 c,t2 c where a.name*=b.name and a.name*=c.name drop table #t