<[EMAIL PROTECTED]> writes: > PROBLEM: > How to FULL JOIN groups=1 from table 'a' with groups=2 from table 'b' > and exclude original NULL groups not thouse which FULL JOIN produce? ...
SELECT * FROM (select * from a where a.groups = 1) AS a FULL OUTER JOIN (select * from b where b.groups = 2) AS b ON (a.num1=b.num1) -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's RemoteDBA services! -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
