I just realized what I posted was perfectly valid SQL. The following
is more what I had in mind:
(SELECT x,y,z FROM A
UNION
SELECT x,y,z FROM B)
AB JOIN C ON C.z = AB.z
This version certainly does throw an error.
Basically I'm wondering if there is a way to get Postgres to treat the
result of a UNION as a table on which I could perform subsequent
operations (like a JOIN).
On Aug 6, 10:43 am, "david.schruth" <dschr(dot)(dot)(dot)(at)gmail(dot)com> 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
> JOIN C ON C.z = B.z
>
> Thanks,
>
> Dave