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 near
        'SELECT MAX(price) FROM shop)' at line 3

Does anyone know why? Does Windows2000 not support Sub-Query?

Regards,
Sumarlidi Einar Dadason

SED - Graphic Design

------------------------------------------
Phone:       (+354) 4615501
Mobile:      (+354) 8960376
Fax:         (+354) 4615503
E-mail:      [EMAIL PROTECTED]
Homepage:    www.sed.is <- New Homepage!
------------------------------------------

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to