更新时间:2023-09-12 16:05:55
INSERT INTO Engg_desp (date,avg,apd)
SELECT makeready.date,sum(ns),ROUND(SUM(ns)/3,2)
FROM makeready
WHERE not exists
(select Engg_desp.date from Engg_desp where makeready.date=Engg_desp.date)
group by makeready.date