On Sat, Feb 19, 2011 at 8:25 AM, Mark Kelly <pgsql(at)wastedtimes(dot)net> wrote:
> 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.
>
>
Hi, Mark.
Take a look at sql UNION--this is not postgresql specific.
Sean