Re: [Pgsql-ayuda] Full outer join

El Lun 22 Dic 2003 10:14, jtaaribi escribió:
>
> La consulta sería:
>
> select t1.num, t1.col1, t2.col3
> from t1 full outer join t2 on
> t1.num = t2.num and
> t1.col2 = 1 and
> t2.col4 = 5
>
> Para obtener:
>
> num | col1 | col3
> -----+------------
> 1 | a | xxx
> 2 | b | null
> 5 | null | zzz
>
> Pero se produce un error: "FULL JOIN is only supported with mergejoinable
> join conditions"

select t.num, t.col1, t.col3
from (SELECT t1.num,t1.col1, t2.col3 FROM
t1 full outer join t2 on
t1.num = t2.num)
WHERE
t1.col2 = 1 and
t2.col4 = 5

--
10:49:01 up 26 days, 17:05, 4 users, load average: 0.15, 0.37, 0.53
-----------------------------------------------------------------
Martín Marqués | select 'mmarques' || '@' || 'unl.edu.ar'
Centro de Telematica | DBA, Programador, Administrador
Universidad Nacional
del Litoral
-----------------------------------------------------------------