create view v_name as
select fdm,pgsl,lzsl,pgsl+lzsl hjsl from(
select tb1.fdm,pgsl,lzsl from tb1,tb2 where tb1.fdm=tb2.fdm(+)
union all
select tb2.fdm,pgsl,lzsl from tb1,tb2 where tb1.fdm(+)=tb2.fdm
and pgsl is null);
select fdm,pgsl,lzsl,pgsl+lzsl hjsl from(
select tb1.fdm,pgsl,lzsl from tb1,tb2 where tb1.fdm=tb2.fdm(+)
union all
select tb2.fdm,pgsl,lzsl from tb1,tb2 where tb1.fdm(+)=tb2.fdm
and pgsl is null);
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货