在不存在条件的情况下插入多行

本文介绍了在不存在条件的情况下插入多行的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

当我使用查询

Hi, When I''m using the query

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) group by makeready.date

插入多个值时，我收到以下错误消息:每个GROUP BY表达式必须至少包含一个不是外部引用的列." 此错误有解决方案吗?... 谢谢

to insert multiple values I''m getting the error as : "Each GROUP BY expression must contain at least one column that is not an outer reference." Is there any solution for this error....? Thank you

推荐答案

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