SQL Query引发了这个问题 [英] SQL Query raise the problem

问题描述

我正在编写以下Sql语句，但它引发了一个错误，如



列''GR_Process_Outward.Material_Code''在选择列表中无效，因为它不包含在聚合函数或GROUP BY子句中。



- >我需要GR_Process_Outward.Material_Code字段



我的sql语句是

Hi,

i''m writing following Sql statement but it raises an error like

"Column ''GR_Process_Outward.Material_Code'' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause."

-->i m require "GR_Process_Outward.Material_Code" field

My sql statement is

select Product_Material_Master.Product_Name, SUM(GR_Process_Outward.Qty),GR_Process_Outward.Material_Code
from Product_Material_Master,GR_Process_Outward
where Product_Material_Master.Product_Code=GR_Process_Outward.Product_Code
AND Receipt_No=5 GROUP BY Product_Name

请帮忙me.pls



提前感谢

pls help me.pls

thanks in advance

推荐答案

你需要删除 GR_Process_Outward来自 GROUP BY 查询的.Material_Code 或将其移至 GROUP BY 子句（其中）将导致不同的结果）。

You need to remove GR_Process_Outward.Material_Code from your GROUP BY query or move it into the GROUP BY clause (which will lead to different results).

尝试以下查询：

Try the following Query:

select Product_Material_Master.Product_Name, SUM(GR_Process_Outward.Qty),GR_Process_Outward.Material_Code
from Product_Material_Master,GR_Process_Outward
where Product_Material_Master.Product_Code=GR_Process_Outward.Product_Code
AND Receipt_No=5 GROUP BY Product_Material_Master.Product_Name, GR_Process_Outward.Material_Code 

试试这个...

Try with this...

select Product_Material_Master.Product_Name, SUM(GR_Process_Outward.Qty),GR_Process_Outward.Material_Code
from Product_Material_Master,GR_Process_Outward
where Product_Material_Master.Product_Code=GR_Process_Outward.Product_Code
AND Receipt_No=5 
GROUP BY Product_Name,Material_Code

每当您使用群组功能时，无论您在选择查询中选择了什么，您都可以调用所有列。聚合函数，如（sum，avg ...）

whenever you used the Group function definately you can call all the columns whatever you select in select query except that aggregate functions like( sum, avg...)

这篇关于SQL Query引发了这个问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！