Update avec jointure sur 3 tables
bheissat
Messages postés
2
Date d'inscription
vendredi 4 septembre 2009
Statut
Membre
Dernière intervention
4 septembre 2009
-
4 août 2009 à 11:23
bitangm Messages postés 13 Date d'inscription jeudi 20 août 2009 Statut Membre Dernière intervention 24 août 2010 - 11 août 2009 à 22:43
bitangm Messages postés 13 Date d'inscription jeudi 20 août 2009 Statut Membre Dernière intervention 24 août 2010 - 11 août 2009 à 22:43
A voir également:
- Update avec jointure oracle
- Sql update plusieurs lignes ✓ - Forum SQL
- Sauvegarde oracle ✓ - Forum Delphi / Pascal
- Dbf oracle - Forum SQL
- Oracle script ✓ - Forum VB.NET
- Jointure ✓ - Forum SQL
1 réponse
bitangm
Messages postés
13
Date d'inscription
jeudi 20 août 2009
Statut
Membre
Dernière intervention
24 août 2010
11 août 2009 à 22:43
11 août 2009 à 22:43
Tout dépend du SGBD que tu utilise,
tu trouveras ci-dessous des exemples complets
--Pour Access, MySQL
UPDATE APPLICATION_DM As APD, AVANCEMENT_DM AS AD, IDENTIFICATION_AM AS IA
SET APD.ETAT_VALIDATION = 'VERIFIE OK'
WHERE (AD.NUMERO_DM = APD.NUMERO_DM)
AND (AD.NUMERO_DM=IA.NUMERO_DM)
AND (AD.ID_OUTIL='7FN')
AND (AD.AVANCEMENT='CLOSE')
AND (IA.APPLICABILITE='V2_1')
AND (APD.ETAT_VALIDATION='NO VERIFIE');
--Pour SQL SERVER
UPDATE APD
SET APD.ETAT_VALIDATION = 'VERIFIE OK'
FROM APPLICATION_DM As APD, AVANCEMENT_DM AS AD, IDENTIFICATION_AM AS IA
WHERE (AD.NUMERO_DM = APD.NUMERO_DM)
AND (AD.NUMERO_DM=IA.NUMERO_DM)
AND (AD.ID_OUTIL='7FN')
AND (AD.AVANCEMENT='CLOSE')
AND (IA.APPLICABILITE='V2_1')
AND (APD.ETAT_VALIDATION='NO VERIFIE');
--Pour Oracle, FireBird, InterBase, DB2...
Formule 1 :
=========
UPDATE APPLICATION_DM As APD
SET APD.ETAT_VALIDATION = 'VERIFIE OK'
WHERE APD.ETAT_VALIDATION='NO VERIFIE'
AND APD.NUMERO_DM IN
(SELECT IA.NUMERO_DM
FROM AVANCEMENT_DM AS AD, IDENTIFICATION_AM AS IA
WHERE (AD.NUMERO_DM = APD.NUMERO_DM)
AND (AD.NUMERO_DM=IA.NUMERO_DM)
AND (AD.ID_OUTIL='7FN')
AND (AD.AVANCEMENT='CLOSE')
AND (IA.APPLICABILITE='V2_1')
)
;
Formule 2 :
=========
UPDATE APPLICATION_DM As APD
SET APD.ETAT_VALIDATION = 'VERIFIE OK'
WHERE APD.ETAT_VALIDATION='NO VERIFIE'
AND EXISTS
(SELECT IA.NUMERO_DM
FROM AVANCEMENT_DM AS AD, IDENTIFICATION_AM AS IA
WHERE (AD.NUMERO_DM = APD.NUMERO_DM)
AND (AD.NUMERO_DM=IA.NUMERO_DM)
AND (AD.ID_OUTIL='7FN')
AND (AD.AVANCEMENT='CLOSE')
AND (IA.APPLICABILITE='V2_1')
)
;
tu trouveras ci-dessous des exemples complets
--Pour Access, MySQL
UPDATE APPLICATION_DM As APD, AVANCEMENT_DM AS AD, IDENTIFICATION_AM AS IA
SET APD.ETAT_VALIDATION = 'VERIFIE OK'
WHERE (AD.NUMERO_DM = APD.NUMERO_DM)
AND (AD.NUMERO_DM=IA.NUMERO_DM)
AND (AD.ID_OUTIL='7FN')
AND (AD.AVANCEMENT='CLOSE')
AND (IA.APPLICABILITE='V2_1')
AND (APD.ETAT_VALIDATION='NO VERIFIE');
--Pour SQL SERVER
UPDATE APD
SET APD.ETAT_VALIDATION = 'VERIFIE OK'
FROM APPLICATION_DM As APD, AVANCEMENT_DM AS AD, IDENTIFICATION_AM AS IA
WHERE (AD.NUMERO_DM = APD.NUMERO_DM)
AND (AD.NUMERO_DM=IA.NUMERO_DM)
AND (AD.ID_OUTIL='7FN')
AND (AD.AVANCEMENT='CLOSE')
AND (IA.APPLICABILITE='V2_1')
AND (APD.ETAT_VALIDATION='NO VERIFIE');
--Pour Oracle, FireBird, InterBase, DB2...
Formule 1 :
=========
UPDATE APPLICATION_DM As APD
SET APD.ETAT_VALIDATION = 'VERIFIE OK'
WHERE APD.ETAT_VALIDATION='NO VERIFIE'
AND APD.NUMERO_DM IN
(SELECT IA.NUMERO_DM
FROM AVANCEMENT_DM AS AD, IDENTIFICATION_AM AS IA
WHERE (AD.NUMERO_DM = APD.NUMERO_DM)
AND (AD.NUMERO_DM=IA.NUMERO_DM)
AND (AD.ID_OUTIL='7FN')
AND (AD.AVANCEMENT='CLOSE')
AND (IA.APPLICABILITE='V2_1')
)
;
Formule 2 :
=========
UPDATE APPLICATION_DM As APD
SET APD.ETAT_VALIDATION = 'VERIFIE OK'
WHERE APD.ETAT_VALIDATION='NO VERIFIE'
AND EXISTS
(SELECT IA.NUMERO_DM
FROM AVANCEMENT_DM AS AD, IDENTIFICATION_AM AS IA
WHERE (AD.NUMERO_DM = APD.NUMERO_DM)
AND (AD.NUMERO_DM=IA.NUMERO_DM)
AND (AD.ID_OUTIL='7FN')
AND (AD.AVANCEMENT='CLOSE')
AND (IA.APPLICABILITE='V2_1')
)
;
