INSERT INTO ResultTable1 ( [Tonnages à passer], [PRE (50) 55], [PRE (50) 56], [PRE (50) 91], [PRE (50) 6x], [PRE (52) 55], [PRE (52) 56], [PRE (52) 91], [PRE (52) 6x], [PRH (52) 55], [PRH (52) 56], [PRH (52) 91], [PRH (52) 6x] )
SELECT ResultTable1.[Tonnages à passer], R01_PRE50_55.SommeDePOIDS, R02_PRE50_56.SommeDePOIDS, R03_PRE50_91.SommeDePOIDS, R04_PRE50_6x.SommeDePOIDS, R05_PRE52_55.SommeDePOIDS, R06_PRE52_56.SommeDePOIDS, R07_PRE52_91.SommeDePOIDS, R08_PRE52_6x.SommeDePOIDS, R09_PRH52_55.SommeDePOIDS, R10_PRH52_56.SommeDePOIDS, R10_PRH52_91.SommeDePOIDS, R11_PRH52_6x.SommeDePOIDS
FROM ResultTable1, R01_PRE50_55, R02_PRE50_56, R03_PRE50_91, R04_PRE50_6x, R05_PRE52_55, R06_PRE52_56, R07_PRE52_91, R08_PRE52_6x, R09_PRH52_55, R10_PRH52_56, R10_PRH52_91, R11_PRH52_6x;
Partager