Combining queries - Mailing list pgsql-novice

From Mark Kelly
Subject Combining queries
Date
Msg-id 201102191325.48594.pgsql@wastedtimes.net
Whole thread Raw
Responses Re: Combining queries
List pgsql-novice
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

pgsql-novice by date:

Previous
From: Michael Wood
Date:
Subject: Re: Help loading data. Error code page 850
Next
From: Sean Davis
Date:
Subject: Re: Combining queries