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