Insert into fa_device_alarm_id(code,ctime,cuid,devicemodel) (SELECT log.eaNo,1624698742,1,de.deviceModel FROM `emsAlarm` log, device de where log.devCode=de.deviceCode group by log.eaNo,de.deviceModel)