V_CONSTITUENTAPPEAL_WITHNULLCONSTITUENTSECURITY

create view V_CONSTITUENTAPPEAL_WITHNULLCONSTITUENTSECURITY
as
    select
        CONSTITUENTAPPEAL.ID
    from
        dbo.CONSTITUENTAPPEAL
        left join dbo.CONSTIT_SECURITY_ATTRIBUTE_ASSIGNMENT
            on CONSTITUENTAPPEAL.CONSTITUENTID = CONSTIT_SECURITY_ATTRIBUTE_ASSIGNMENT.CONSTITUENTID
    where
        CONSTIT_SECURITY_ATTRIBUTE_ASSIGNMENT.CONSTITUENTID is null