Hi.
If I have two queries:
SELECT pub_id as id, email FROM publication WHERE email_accepted = TRUE;
and
SELECT contact_id as id, email FROM person WHERE email_accepted = TRUE;
is there any way I could combine these into a single query? I'd like to be
able to create a view of all email-able entities in the system.
Thanks,
Mark