加别名
select * into CustomerAndSale
from (select 'CustomerTB' as soure,CustId,ShipCity
from Customer
union all
select 'SaleTB' as soure,CustId,null as ShipCity
from Sale) aa
select * into CustomerAndSale
from (select 'CustomerTB' as soure,CustId,ShipCity
from Customer
union all
select 'SaleTB' as soure,CustId,null as ShipCity
from Sale) aa
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货