V_CONSTITUENTAPPEAL_WITHNULLCONSTITSECURITY

create view BBDW.[V_CONSTITUENTAPPEAL_WITHNULLCONSTITSECURITY]
as
    select
        [FACT_CONSTITUENTAPPEAL].[CONSTITUENTAPPEALSYSTEMID] as [ID]
    from
        BBDW.[FACT_CONSTITUENTAPPEAL]
        left join BBDW.[FACT_CONSTITUENTSECURITYGROUPASSIGNMENT] on [FACT_CONSTITUENTAPPEAL].[CONSTITUENTDIMID] = [FACT_CONSTITUENTSECURITYGROUPASSIGNMENT].[CONSTITUENTDIMID]
    where
        [FACT_CONSTITUENTSECURITYGROUPASSIGNMENT].[CONSTITUENTDIMID] is null;