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 );
Partager