1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
| CREATE Table logement_info
(Id_logement int,
Code_colonne varchar(10),
Valeur_colonne varchar(2000))
CREATE Table logement_recup
(Id_logemnent int,
Colonne1 varchar(10),
Colonne2 varchar(10),
Colonne3 varchar(10))
UPDATE logement_recup
SET Colonne1 = (SELECT Valeur_colonne FROM logement_info LI WHERE Code_colonne = 1 AND LI.Id_logemnent = logement_recup.Id_logemnent),
Colonne2 = (SELECT Valeur_colonne FROM logement_info LI WHERE Code_colonne = 2 AND LI.Id_logemnent = logement_recup.Id_logemnent),
Colonne3 = (SELECT Valeur_colonne FROM logement_info LI WHERE Code_colonne = 3 AND LI.Id_logemnent = logement_recup.Id_logemnent) |
Partager