Bonjour,

Voici une requête d'update qui semble correcte du point de vue de la syntaxe, mais qui refuse de s'exécuter...

si vous pouvez m'aider...

Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
UPDATE
  APOGEE.ELP_CHG_TYP_HEU
SET
  APOGEE.ELP_CHG_TYP_HEU.COD_COLL_TH=APOGEE.COLLECTION.COD_COL
WHERE
  (APOGEE.ELP_CHG_TYP_HEU.COD_ELP,APOGEE.ELP_CHG_TYP_HEU.COD_TYP_HEU,APOGEE.ELP_CHG_TYP_HEU.COD_ANU) IN
( SELECT DISTINCT
    apogee.element_pedagogi.cod_elp,
    apogee.elp_chg_typ_heu.cod_typ_heu,
    apogee.elp_charge_ens.cod_anu,
    apogee.collection.cod_col
FROM
    apogee.collection
    INNER JOIN apogee.groupe ON apogee.collection.cod_col = apogee.groupe.cod_col
    INNER JOIN apogee.gpe_obj ON apogee.groupe.cod_gpe = apogee.gpe_obj.cod_gpe
    INNER JOIN apogee.elp_chg_typ_heu ON apogee.elp_chg_typ_heu.cod_elp = apogee.gpe_obj.cod_elp
                                         AND apogee.elp_chg_typ_heu.cod_typ_heu = apogee.groupe.cod_tgr
    INNER JOIN apogee.elp_charge_ens ON apogee.elp_charge_ens.cod_elp = apogee.elp_chg_typ_heu.cod_elp
                                        AND apogee.elp_charge_ens.cod_anu = apogee.elp_chg_typ_heu.cod_anu
    INNER JOIN apogee.element_pedagogi ON apogee.element_pedagogi.cod_elp = apogee.elp_charge_ens.cod_elp
WHERE
    apogee.elp_charge_ens.cod_anu = '2018'
    AND apogee.elp_charge_ens.tem_cal_chg = 'O'
    AND apogee.elp_chg_typ_heu.nbr_grp_th_mod IS NULL
    AND ( apogee.collection.daa_fin_col IS NULL
          OR apogee.collection.daa_fin_col >= 2018 )
    AND apogee.groupe.cod_cgp IS NULL
);