JOIN a UNION - Mailing list pgsql-general

From david.schruth
Subject JOIN a UNION
Date
Msg-id 6919e016-d2b1-4abf-81b4-cd2d75588db6@f20g2000prn.googlegroups.com
Whole thread Raw
List pgsql-general
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

pgsql-general by date:

Previous
From: Jeff Davis
Date:
Subject: Re: Empty Updates, ON UPDATE triggers and Rules
Next
From: "david.schruth"
Date:
Subject: Re: JOIN a UNION