Payor

SELECT distinct DRG_CD

from [SiemensHealthPlanData].[dbo].[unitedHealth9digitsDrugCode] as digits

where DRG_CD !='' and not exists(

select *

from [SiemensHealthPlanData].[dbo].[nationalDrugCode] as code

where digits.DRG_CD = code.DRG_CD

)



select COUNT(*)

from [SiemensHealthPlanData].[dbo].[unitedHealth9digitsDrugCode]

where DRG_CD != ''





SELECT [key]

,digits.[DRG_CD], Description

FROM [SiemensHealthPlanData].[dbo].[unitedHealth9digitsDrugCode] as digits,

[SiemensHealthPlanData].[dbo].[nationalDrugCode] as code

where digits.DRG_CD = code.DRG_CD