my sql is

SELECT product_category
FROM product GROUP BY product_category

and i get the error:

you tried to execute a query that does not include the specified expression 'product_category' as part of an aggregate function.

What the hell does that mean?!

I have the same query on another age and it works fine.

?Simon

this usually happens if you misspell the field name - make sure that you have got the correct spelling of product_category after the group by part of the SQL statement. you might have spelled it product_catagory by mistake on that page, but spelled it correctly on the other pages.

cheers for this - will have a look.