Create view sxxx
as
select case when table1.xx is null then table2.xx else table1.xx end as xx,
table2.yy as name2,
table1.zz as name3
as
select case when table1.xx is null then table2.xx else table1.xx end as xx,
table2.yy as name2,
table1.zz as name3
as
select isnull(table1.xx,table2.xx) as name1,
table2.yy as name2,
table1.zz as name3
.....
from table1,table2
where 联接条件