Unanswered: Subquery doesn't work, syntax is correct???
I just installed Mysql 4.0.18
I tried to run ths sql statement
Select a.price, a.name
where a.price = (Select max(price) from rooms);
I don't believe the syntax is wrong. Can anyone help me? I checked the data in the [Rooms] table which are all valid.
When I run:
Select max(price) from rooms;
It works, but when its in a subquery it doesn't.
I get this error:
Error 1064: You have an error in your SQL syntax. Check the manual that correspond to your MYSQL server version for the right syntax to use near 'Select max(price) from rooms' at line 3