Forums PostgreSQL.fr

mich30

Membre

jointure externe postgres ?

Bonjour
j'arrive pas a faire une jointure externe de id_parc1,id_parc2
merci

select id_parc2,p1.nblog1990,p2.nblog2006 from
(
select id_parc as id_parc1 ,count(*)  as nblog1990
from bat  p1
where dte in ('1','2') and ja < '1991' or ja is null
and id_parc ='04049AL1080'
group by id_parc
)p1
,
(
select id_parc as id_parc2 ,count(*)  as nblog2006
from bat p1
where dte in ('1','2') and id_parc ='04049AL1080'
group by id_parc
)p2
where
( id_parc1 =  id_parc2);

mich30

Membre

Re : jointure externe postgres ?

voir ci dessous ca marche pas !
coment on fais ? merci

select p2.id_parc,p1.nblog1990,p2.nblog2006 from

(
select id_parc  ,count(*)  as nblog1990
from bat p1
where dte in ('1','2')
and ja < '1991' or ja is null
and id_parc ='04049AL1080'
group by id_parc
)p1
,
(
select id_parc  ,count(*)  as nblog2006
from bat p1
where dte in ('1','2')
and id_parc ='04049AL1080'
group by id_parc
)p2,
LEFT JOIN p2.id_parc1 AS c ON p1.id_parc = p2.id_parc