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.
Any help is greatly appreciated