1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
|
SELECT DISTINCT
/*
une 20aine de champs ici,
avec a chaque fois un case, replace ou convert
*/
INTO
T_TMP
FROM
table1
JOIN table2 ON table2.champ1 = table1.champ2
JOIN table3 ON table3.champ1 = table2.champ3
JOIN table4 ON table4.champ1 = table2.champ4
JOIN table5 ON table5.champ5 = table1.champ5 AND table5.champ6 = Bchamp6
LEFT JOIN table6 ON table6.champ5 = table1.champ5 AND REPLACE(table6.champ7,' ','') = REPLACE(table3.champ8,' ','')
LEFT JOIN table7 ON table7.champ5 = table1.champ5 AND table7.champ2 = table1.champ2
ORDER BY
table1.champ5,
table2.champ8 |
Partager