V_CONSTITUENTAPPEAL_WITHNULLSITESECURITY

create view BBDW.[V_CONSTITUENTAPPEAL_WITHNULLSITESECURITY]
as
    select 
    distinct [FACT_CONSTITUENTAPPEAL].[CONSTITUENTAPPEALSYSTEMID] as [ID]
    from BBDW.[FACT_CONSTITUENTAPPEAL]
    inner join BBDW.[DIM_APPEAL] on [DIM_APPEAL].[APPEALDIMID] = [FACT_CONSTITUENTAPPEAL].[APPEALDIMID]
    where [DIM_APPEAL].[SITEDIMID] = 0;