你可能在找 UNION ALL . 更多信息请参见postgres文档：
https://www.postgresql.org/docs/8.3/queries-union.html

请使用下面的查询，

SELECT appui.pa, COUNT(appui.gid) AS appui_non_lance 
FROM genie_civil.v_appui appui
JOIN suivi.v_contour_aerien aer ON aer.id = appui.contour_etude
WHERE num_appui LIKE 'E%'
AND etat_appui != 'Non utilisé' AND type_travaux != 'artère neuve' AND avancement_etude_app = 'non renseigné'
AND date_envoi_pv IS NULL AND date_retour_pv IS NULL AND etat_pv = '--Non Renseigné--'
AND aer.date_depot_erdf IS NULL AND aer.etat_etude_erdf = 'NC' AND aer.etat_affaire IS NULL
AND date_com IS NULL AND valid_com IS NULL
--AND date_envoi_executant_app IS NULL
AND date_retour_tvx_appui IS NULL AND aer.etat_aat = '--Non renseigné--' AND date_tfx IS NULL
AND valid_tfx IS NULL AND aer.date_envoi_d2 IS NULL 
GROUP BY appui.pa

UNION ALL

SELECT appui.pa, COUNT(appui.gid) AS appui_en_releve FROM genie_civil.v_appui appui
JOIN suivi.v_contour_aerien aer ON aer.id = appui.contour_etude
WHERE num_appui LIKE 'E%' 
AND etat_appui != 'Non utilisé' AND avancement_etude_app IN('à relever', 'en cours relevé', 'à contrôler relevé')
AND date_envoi_pv IS NULL AND date_retour_pv IS NULL AND etat_pv = '--Non Renseigné--' AND date_com IS NULL
AND valid_com IS NULL 
--AND date_envoi_executant_app IS NULL
AND date_retour_tvx_appui IS NULL AND aer.date_depot_erdf IS NULL AND aer.etat_etude_erdf ='NC'
AND aer.etat_affaire IS NULL AND aer.etat_aat = '--Non renseigné--'  AND date_tfx IS NULL 
AND valid_tfx IS NULL AND aer.date_envoi_d2 IS NULL
GROUP BY appui.pa;

我想你只是在找两个不同的罪名。这种方法最好，因为您只扫描表一次。我已经将两个查询的共同条件移到 where 条款，而其他条款是各自条款的一部分 case 表达。

SELECT appui.pa,
    COUNT(CASE WHEN
            type_travaux != 'artère neuve'
        AND avancement_etude_app = 'non renseigné'
        AND aer.date_depot_erdf IS NULL
        AND aer.etat_etude_erdf = 'NC'
    THEN 1 END) AS appui_non_lance,
    COUNT(CASE WHEN
            etat_appui != 'Non utilisé'
        AND avancement_etude_app IN ('à relever', 'en cours relevé', 'à contrôler relevé')
    THEN 1 END) AS appui_en_releve
FROM genie_civil.v_appui appui INNER JOIN suivi.v_contour_aerien aer
    ON aer.id = appui.contour_etude
WHERE
        num_appui LIKE 'E%'
    AND etat_appui != 'Non utilisé'
    AND etat_pv = '--Non Renseigné--'
    AND date_envoi_pv IS NULL
    AND date_retour_pv IS NULL
    AND aer.etat_affaire IS NULL
    AND date_com IS NULL
    AND valid_com IS NULL
    --AND date_envoi_executant_app IS NULL
    AND aer.etat_aat = '--Non renseigné--'
    AND date_tfx IS NULL
    AND date_retour_tvx_appui IS NULL
    AND valid_tfx IS NULL
    AND aer.date_envoi_d2 IS NULL
GROUP BY appui.pa;