An error occurred executing the following query, and page execution has been terminated.

SELECT DISTINCT T_Taxrate, V_ID, V_Accessory, V_Price, V_Weight, V_RRP, V_PDF, V_Tax, V_ProductID, V_CodeNumber, V_Quantity, V_Quantity, V_QuantityWarnLevel, V_Name1 As OrderByBit, V_Name1, cast(V_Desc1 as nvarchar(4000)) as V_Desc1, MIN(QD_ID) As QuantityDiscount FROM (tblCactuShop1Versions v INNER JOIN tblCactuShop1TaxRates tr ON v.V_Tax = tr.T_ID) LEFT JOIN tblCactuShop1QuantityDiscounts qd ON v.V_ID = qd.QD_VersionID WHERE V_Live = 'y' AND V_CustomerGroupID IN (0,0) AND V_ProductID=473 AND V_Name1 <> '' GROUP BY T_Taxrate, V_ID, V_Price, V_Weight, V_RRP, V_Tax, V_ProductID, V_CodeNumber, V_Quantity, V_QuantityWarnLevel, V_Name1, V_Name1, cast(V_Desc1 as nvarchar(4000)) ORDER BY V_Name1

Error Description : Column 'tblCactuShop1Versions.V_Accessory' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

Page of error : /404.asp

Query String :

404;http://www.barcodestore.co.uk:80/Patient+/c-1-163/