MySQL Error 1054: Unknown column in sentence

Question

Query:

  SELECT SUM(ProductCost) 
    FROM `tblBasket` 
GROUP BY ProductCode
  HAVING BasketSessionID = '3429782d79c68834ea698bb4116eef5e'

Error display like:

1054 - Unknown column 'BasketSessionID' in 'having clause'

What is the error in my request?

Answer 1

Try using the where clause instead of the having clause:

SELECT SUM(ProductCost) 
FROM `tblBasket` 
WHERE BasketSessionID ='3429782d79c68834ea698bb4116eef5e'
GROUP BY ProductCode

Answer 2

I think you want to use a where clause that does not have.

Answer 3

HAVING filters the units. You should try GROUP BY.