哥们,你要的是这个吧,我建图去了一把题目删了换一句话了?
代码是这样的,
create view tab (dw,gyh,gyxm,zw,grtc,tdtc) as (
select dw,gyh,gyxm,null,null,tdtc from tab1
union all select dw,gyh,gyxm,zw,grtc,null from tab2
);
select * from tab;