Re: JOIN a UNION - Mailing list pgsql-general

From Pavel Stehule
Subject Re: JOIN a UNION
Date
Msg-id 162867790908061152y331899ei3caffee86dde71a3@mail.gmail.com
Whole thread Raw
In response to Re: JOIN a UNION  (David Fetter <david@fetter.org>)
List pgsql-general
2009/8/6 David Fetter <david@fetter.org>:
> On Thu, Aug 06, 2009 at 08:33:57PM +0200, Pavel Stehule wrote:
>> Hello
>>
>> SELECT ... FROM
>>   (SELECT ... FROM A
>>    UNION ALL
>>    SELECT FROM B) s1
>>  JOIN C IN C.z = s1.z;
>
> That last line should read:
>
>    JOIN C ON C.z = s1.z;

I am sorry

Pavel
>
> Cheers,
> David.
> --
> David Fetter <david@fetter.org> http://fetter.org/
> Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
> Skype: davidfetter      XMPP: david.fetter@gmail.com
>
> Remember to vote!
> Consider donating to Postgres: http://www.postgresql.org/about/donate
>

pgsql-general by date:

Previous
From: David Fetter
Date:
Subject: Re: JOIN a UNION
Next
From: "david.schruth"
Date:
Subject: Re: JOIN a UNION