MySQL Error Occured
1054: Unknown column 'CubeCart_inventory.inventory.price' in 'group statement'

QUERY = SELECT CubeCart_cats_idx.cat_id, CubeCart_cats_idx.productId, productCode, quantity, description, image, price, name, popularity, sale_price, stock_level, useStockLevel FROM CubeCart_cats_idx INNER JOIN CubeCart_inventory ON CubeCart_cats_idx.productId = CubeCart_inventory.productId WHERE sale_price > 0 GROUP BY CubeCart_inventory.inventory.price