Le portail francophone de la géomatique

WITH cpt AS (

SELECT proprietaires.dnupro, proprietaires.ccocom,
    Count(proprietaires.idu) cpt_pro
FROM proprietaires
GROUP BY proprietaires.dnupro, proprietaires.ccocom
) , 
grp_pro_idu AS(

SELECT proprietaires.idu, proprietaires.dnupro, proprietaires.ccocom,
    Count(proprietaires.idu) cpt_idu
FROM proprietaires
GROUP BY proprietaires.dnupro, proprietaires.idu, proprietaires.ccocom
)

SELECT grp_pro_idu.idu idu , grp_pro_idu.dnupro dnupro, cpt.cpt_pro, cpt_pro
, parcelles.geom geom
FROM  cpt
 JOIN grp_pro_idu ON cpt.dnupro = grp_pro_idu.dnupro AND cpt.ccocom = grp_pro_idu.ccocom
 JOIN parcelles ON grp_pro_idu.idu = parcelles.idu