create view test_view as
(select ContainerID , ElemID, dataDate , HD as HDXL
from A
union
select ContainerID , ElemID, dataDate , XL as HDXL
from B)
(select ContainerID , ElemID, dataDate , HD as HDXL
from A
union
select ContainerID , ElemID, dataDate , XL as HDXL
from B)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货