V_CONSTITUENTAPPEAL_WITHNULLSITESECURITY

Fields

Field	Field Type	Null	Description
ID	uniqueidentifier

Definition

Copy


create view V_CONSTITUENTAPPEAL_WITHNULLSITESECURITY
as
    select distinct CONSTITUENTAPPEAL.ID
    from dbo.CONSTITUENTAPPEAL
    inner join dbo.APPEAL
        on APPEAL.ID = CONSTITUENTAPPEAL.APPEALID
    where APPEAL.SITEID is null