I have a sql that uses not exist, but I am doubtful on what column it is trying to match the Not Exist. Any help is highly appreciated, Thank You in advance.
select
C.clinic_id,
P.provider_id,
P.eff_date,
'PROV'
--,@etl_job_id
--,@run_date
from provider P
join clinic C on P.primary_ein = C.primary_ein
and C.source_type = 'PROV'
and (C.exp_date is null or C.exp_date >= GETDATE())
where P.cycle_id = 854 --1012
and P.provider_id is not null
and NOT exists
(select 1
FROM health H
where P.provider_id = H.provider_id
and C.clinic_id = H.clinic_id
and H.staff_id is null)
The first column in health H table is an identity column 'Entity_id'.
Is the above query trying to see C.clinic_id that does on exist in H.EntityID list in the sub query?
how does this sql work?
Posted - 02/18/2013 : 11:48:31
