INSERT INTO tblDest ( date, journée, champ ) SELECT [TOTO].date, [TOTO].journée, [champ1] & "-" & [champ2] AS champ FROM [TOTO] Union SELECT [TOTO].date, [TOTO].journée, [champ1] & "-" & [champ3] AS champ FROM [TOTO] Union SELECT [TOTO].date, [TOTO].journée, [champ1] & "-" & [champ4] AS champ FROM [TOTO] Union SELECT [TOTO].date, [TOTO].journée, [champ1] & "-" & [champ5] AS champ FROM [TOTO];
INSERT INTO tblDest ( date, journée, champ ) SELECT [TOTO].date, [TOTO].journée, [TOTO].champ FROM [TOTO] Union SELECT [TOTO].date, [TOTO].journée, [champ1] & "-" & [champ3] AS champ FROM [TOTO];
INSERT INTO tblDest ( date, journée, champ ) SELECT [TOTO].date, [TOTO].journée, [TOTO].champ FROM (SELECT [TOTO].date, [TOTO].journée, [champ1] & "-" & [champ2] AS champ FROM [TOTO] Union SELECT [TOTO].date, [TOTO].journée, [champ1] & "-" & [champ3] AS champ FROM [TOTO]);
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionINSERT INTO tblDest ( date, journée, champ ) SELECT date, journée, champ FROM ( SELECT [TOTO].date, [TOTO].journée, [champ1] & "-" & [champ2] AS champ FROM [TOTO] Union SELECT [TOTO].date, [TOTO].journée, [champ1] & "-" & [champ3] AS champ FROM [TOTO] Union SELECT [TOTO].date, [TOTO].journée, [champ1] & "-" & [champ4] AS champ FROM [TOTO] Union SELECT [TOTO].date, [TOTO].journée, [champ1] & "-" & [champ5] AS champ FROM [TOTO] ) ;