Re: JOIN a UNION

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...@gmail.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