36 lines
991 B
SQL
36 lines
991 B
SQL
INSERT INTO Bauteile (
|
|
TXLCode,
|
|
OL1, OL2, OW1, OW2,
|
|
R11, R12, R13,
|
|
R21, R22, R23,
|
|
R31, R32, R33,
|
|
R41, R42, R43,
|
|
LW, CW,
|
|
MessComm, RauComm
|
|
) SELECT
|
|
`3040_messdaten`.`TXLCode` AS `TXLCode`,
|
|
`3040_messdaten`.`ol1` AS `OL1`,
|
|
`3040_messdaten`.`ol2` AS `OL2`,
|
|
`3040_messdaten`.`ow1` AS `OW1`,
|
|
`3040_messdaten`.`ow2` AS `OW2`,
|
|
`3040_messdaten`.`r11` AS `R11`,
|
|
`3040_messdaten`.`r12` AS `R12`,
|
|
`3040_messdaten`.`r13` AS `R13`,
|
|
`3040_messdaten`.`r21` AS `R21`,
|
|
`3040_messdaten`.`r22` AS `R22`,
|
|
`3040_messdaten`.`r23` AS `R23`,
|
|
`3040_messdaten`.`r31` AS `R31`,
|
|
`3040_messdaten`.`r32` AS `R32`,
|
|
`3040_messdaten`.`r33` AS `R33`,
|
|
`3040_messdaten`.`r41` AS `R41`,
|
|
`3040_messdaten`.`r42` AS `R42`,
|
|
`3040_messdaten`.`r43` AS `R43`,
|
|
`3040_rauheiten`.`lw` AS `LW`,
|
|
`3040_rauheiten`.`cw` AS `CW`,
|
|
`3040_messdaten`.`comment` AS `MessComm`,
|
|
`3040_rauheiten`.`comment` AS `RauComm`
|
|
FROM 3040_messdaten, 3040_rauheiten
|
|
WHERE
|
|
`3040_messdaten`.`TXLCode` = `3040_rauheiten`.`TXLCode`;
|
|
|