V_REVENUE_WITHNULLCONSTITUENTSECURITY

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