22,300
社区成员




select [地区],[编号],gas_station_name
,[线下充值]=sum([线下充值])
,[线上充值]=sum([线上充值])
from (
select a.area_code as [地区]
,a.gas_station_code as [编号]
,a.gas_station_name
,[线下充值]=0
,b.deposit as [线上充值]
from A
UNION ALL
select a.area_code as [地区]
,a.gas_station_code as [编号]
,a.gas_station_name
,a.deposit as [线下充值]
,[线上充值]=0
from b
)a
group by [地区],[编号],gas_station_name
select a.area_code as [地区]
,a.gas_station_code as [编号]
,a.gas_station_name
,a.deposit as [线下充值]
,b.deposit as [线上充值]
from A inner join B
on a.area_code=b.area_code
and a.gasstation_code=b.gasstation_code
SELECT t.deposit AS 线下充值,A.deposit AS 线上充值 FROM A.dbo.A JOIN (关联查询的表B) t ON A.gas_station_code = t.gasstation_code