30 lines
775 B
SQL
30 lines
775 B
SQL
INSERT INTO Bauteile (
|
|
TXLCode,
|
|
OL1, OW1,
|
|
R11, R12,
|
|
R21, R22,
|
|
R31, R32,
|
|
R41, R42,
|
|
LW, CW,
|
|
MessComm, RauComm
|
|
) SELECT
|
|
`2121C_messdaten`.`TXLCode` AS `TXLCode`,
|
|
`2121C_messdaten`.`ol` AS `OL1`,
|
|
`2121C_messdaten`.`ow` AS `OW1`,
|
|
`2121C_messdaten`.`r11` AS `R11`,
|
|
`2121C_messdaten`.`r12` AS `R12`,
|
|
`2121C_messdaten`.`r21` AS `R21`,
|
|
`2121C_messdaten`.`r22` AS `R22`,
|
|
`2121C_messdaten`.`r31` AS `R31`,
|
|
`2121C_messdaten`.`r32` AS `R32`,
|
|
`2121C_messdaten`.`r41` AS `R41`,
|
|
`2121C_messdaten`.`r42` AS `R42`,
|
|
`2121C_rauheiten`.`lw` AS `LW`,
|
|
`2121C_rauheiten`.`cw` AS `CW`,
|
|
`2121C_messdaten`.`comment` AS `MessComm`,
|
|
`2121C_rauheiten`.`comment` AS `RauComm`
|
|
FROM 2121C_messdaten, 2121C_rauheiten
|
|
WHERE
|
|
`2121C_messdaten`.`TXLCode` = `2121C_rauheiten`.`TXLCode`;
|
|
|