Re: The problem with FULL JOIN

[Gregory Stark <stark(at)enterprisedb(dot)com>]

<Eugen(dot)Konkov(at)aldec(dot)com> 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!