vwEmailListQueryPeople
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| QueryName | nvarchar(300) | yes | |
| ID | int | ||
| EmailListID | int | ||
| PeopleID | int | ||
| EmailDisplayName | nvarchar(128) | yes | |
| EmailAddress | nvarchar(255) | yes | |
| QueryID | int | yes | |
| GlobalOptOut | bit |
Definition
Copy
CREATE VIEW dbo.vwEmailListQueryPeople
AS
select
elq.QueryName,
elp.*
from emaillist_people elp
left outer join emaillist_query elq
on elp.queryid = elq.QueryID
and elp.emailListId = elq.emailListId