V_CONSTITUENT_WITHNULLSITESECURITY
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier |
Definition
Copy
create view V_CONSTITUENT_WITHNULLSITESECURITY
as
select CONSTITUENT.ID
from dbo.CONSTITUENT
left join dbo.CONSTITUENTSITE
on CONSTITUENTSITE.CONSTITUENTID = CONSTITUENT.ID
where CONSTITUENTSITE.SITEID is null