V_CONSTITUENT_WITHNULLSITESECURITY

create view BBDW.[V_CONSTITUENT_WITHNULLSITESECURITY]
as
    select 
    distinct [DIM_CONSTITUENT].[CONSTITUENTSYSTEMID] as [ID]
    from BBDW.[DIM_CONSTITUENT]
    left join BBDW.[FACT_CONSTITUENTSITE] on [FACT_CONSTITUENTSITE].[CONSTITUENTDIMID] = [DIM_CONSTITUENT].[CONSTITUENTDIMID]
    where [FACT_CONSTITUENTSITE].[CONSTITUENTDIMID] is null;