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...@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
