在不存在条件的情况下插入多行 [英] Insert multiple rows with where not exists condition

问题描述

当我使用查询

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

这篇关于在不存在条件的情况下插入多行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！