hi, im trying to make a subquery with MySQL 4.0.15.

it goes like this:

this query works fine:

SELECT MAX(unitprice)
FROM tblproducts;


This query also works fine:

SELECT productid,productname,unitprice
FROM tblproducts
WHERE unitprice = 271;


This query doesnt work:

SELECT productid,productname,unitprice
FROM tblproducts
WHERE unitprice = ( SELECT MAX(unitprice) FROM tblproducts );

it gives me this error:
Error Code : 1064
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT MAX(unitprice) FROM tblproducts )' at line 3


Can someone please help me?! thanks in advance.

subqueries are not supported until 4.1

try this --