|
INSERT INTO MeasuredData ( LampNumber, SupplyVoltage, LampCurrent, LampWattage, LuminousFlux, x, y, SDCM, CCT, CRI )
SELECT MeasuredData.LampNumber, MeasuredData.SupplyVoltage, MeasuredData.LampCurrent, MeasuredData.LampWattage, MeasuredData.LuminousFlux, MeasuredData.x, MeasuredData.y, MeasuredData.SDCM, MeasuredData.CCT, MeasuredData.CRI
FROM MeasuredData INNER JOIN MeasurementDescription ON MeasuredData.KeyNo = MeasurementDescription.KeyNo IN 'D:\123\SpectralSystem.mdb'
ORDER BY MeasurementDescription.GroupNumber;
应该如何避免重复追加呢,现在原表和目的表的项目都一样,执行一次追加,就有记录,但是是和表中原来的重复的,请问该如何处理。
谢谢
|
|