Query:
SELECT SUM(ProductCost)
FROM `tblBasket`
GROUP BY ProductCode
HAVING BasketSessionID = '3429782d79c68834ea698bb4116eef5e'
Showing Error Like:
1054 - Unknown column 'BasketSessionID' in 'having clause'
What is the mistake in my query?
Try using a where clause in place of the having clause:
SELECT SUM(ProductCost)
FROM `tblBasket`
WHERE BasketSessionID ='3429782d79c68834ea698bb4116eef5e'
GROUP BY ProductCode