本文介绍了在不存在条件的情况下插入多行的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
当我使用查询
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
更多推荐
在不存在条件的情况下插入多行
发布评论