Hi
Sub-Selects are not supported, yet, regardless of OS
At 02:25 16/01/2001 +, SED wrote:
>Hi,
>
>I'm trying to execute the following (as told in MySQL-Manual):
>
> mysql> SELECT article, dealer, price
> -> FROM shop
> -> WHERE price=(SELECT MAX(price) FROM shop)
>
Stupid me, I didn't read the text properly as the following text explains:
Find number, dealer, and price of the most expensive article.
In ANSI SQL this is easily done with a sub-query:
SELECT article, dealer, price
FROM shop
WHERE pr
Hi,
I'm trying to execute the following (as told in MySQL-Manual):
mysql> SELECT article, dealer, price
-> FROM shop
-> WHERE price=(SELECT MAX(price) FROM shop)
-> ;
But I get the following result:
ERROR 1064: You have an error in your SQL syntax nea
