Sql Error Msg 8120

Question

Hi I am getting erorr sql stored procedure Code Select ProductIDProductNameProductCategoryNameSum(UnitsInStock)ProductImageIDSUBSTRING(Description1150) + '...' As DescriptionPriceDeliveryDate from Products INNER JOIN ProductCategory ON ProductCategory.ProductCategoryID = Products.ProductCategoryID Error Message Msg 8120 Level 16 State 1 Line 1 Column 'Products.ProductID' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. How to fix this ?

Manish Dwivedi · Answer

Hi Prasant  you have used the aggregate function SUM in the select so you have to use Group By clause for each selected column like that Select ProductIDProductNameProductCategoryNameSum(UnitsInStock)ProductImageIDSUBSTRING(Description1150) + '...' As DescriptionPriceDeliveryDate from Products INNER JOIN ProductCategory ON ProductCategory.ProductCategoryID = Products.ProductCategoryID group by ProductIDProductNameProductCategoryName ProductImageID DescriptionPriceDeliveryDate by this way you can remove this error.

Krishna Garad · Answer

Give aliases to your table i.e. product and productcategory or you can select the fields with table name as well like bellow product.ProductId product. ProductNameproduct.ProductCategoryName etc...