<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!