Thanks that did it!
On Aug 6, 11:33 am, pavel.steh...@gmail.com (Pavel Stehule) wrote:
> Hello
>
> SELECT ... FROM
> (SELECT ... FROM A
> UNION ALL
> SELECT FROM B) s1
> JOIN C IN C.z = s1.z;
>
> Regards
> Pavel Stehule
>
> 2009/8/6 david.schruth :
>
of a UNION as a table on which I could perform subsequent
operations (like a JOIN).
On Aug 6, 10:43 am, "david.schruth" wrote:
> Simple question:
>
> Is there a way to do something like the following:
>
> SELECT x,y,z FROM A
> UNION
> SELECT x,y,z FROM B
> J
Simple question:
Is there a way to do something like the following:
SELECT x,y,z FROM A
UNION
SELECT x,y,z FROM B
JOIN C ON C.z = B.z
Thanks,
Dave
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgs
