JOIN a UNION

From: "david(dot)schruth" <dschruth(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: JOIN a UNION
Date: 2009-08-06 17:43:43
Message-ID: 6919e016-d2b1-4abf-81b4-cd2d75588db6@f20g2000prn.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message david.schruth 2009-08-06 17:53:05 Re: JOIN a UNION
Previous Message decibel 2009-08-06 17:39:17 Re: Constraint between 2 tables and taking a coherent snapshot of both