Sean Davis wrote on 19.02.2011 14:47:
>
>
> On Sat, Feb 19, 2011 at 8:25 AM, Mark Kelly <pgsql(at)wastedtimes(dot)net <mailto: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.
>
More precisely: UNION ALL to avoid the redundant step that tries to eliminate duplicates
Regards
Thomas