我上传了一个文件，其中包含一个名为[沙盒]。[dbo]。[特殊项目的城市]的城市列表。我正在尝试找出我们如何从清单中的城市中收取收入。
我可以找出我们从数据库中每个城市收取的收入，但是我不确定如何将其与我上传的文件相匹配。
Select individual.[vchCity] as City,sum(staging.[Price_PerLicense]) as Total
From Engine1.DB1.[dbo].[Individual] individual
Join
Engine2.DB2.[dbo].[Daily_License_Report_Detail] staging on individual.[iIndividualId] = staging.[OwnerId]
Group by individual.[vchCity]
我该如何匹配上载文件中的城市。
with CityTotal as(
Select individual.[vchCity] as City,sum(staging.[Price_PerLicense]) as Total
From Engine1.DB1.[dbo].[Individual] individual
Join Engine2.DB2.[dbo].[Daily_License_Report_Detail] staging on individual.[iIndividualId] = staging.[OwnerId]
Group by individual.[vchCity]
)
Select cs.city,ct.total
from [Sandbox].[dbo].[Cities for Special Project] cs
left join cititytotal ct on ct.city = cs.city
这是一种方式