Is it possible to do a full outer join on 3 or more queries? I figured out
how to do 2, but I get an error message when trying to do three
Example:
(works)
select coalesce(a.f1, b.f1) as col_1, b.f2 as col_2
from
(select f1, f2 from table1 where f3 =1) a
FULL OUTER JOIN
(select f1, f2 from table1 where f3 =2) b
on a.f1 = b.f1
(does not work)
select coalesce(a.f1, b.f1,c.f1) as col_1, b.f2 as col_2, c.f2 as col_3
from
(select f1, f2 from table1 where f3 =1) a
FULL OUTER JOIN
(select f1, f2 from table1 where f3 =2) b
FULL OUTER JOIN
(select f1, f2 from table1 where f3 =3) c
on a.f1 = b.f1and a.f1 = c.f1
TIA
Patrick Hatcher
Macys.Com
Legacy Integration Developer
415-932-0610 office
HatcherPT - AIM