version

Please tell me if the MySQL 4.0.2-alpha Windows 95/98/NT/2000/XP (17.2M) supports the subselect command. Thank you ! _ Narcis GRATIANU ICQ#: 13344551 More ways to contact me: http://wwp.icq.com/13344551

select query

When I try this: SELECT article, dealer, price FROM shop s1 WHERE price=(SELECT MAX(s2.price) FROM shop s2 WHERE s1.article = s2.article) LIMIT 0, 100 I got this error message: You have an error in your SQL syntax near 'SELECT MAX(s2.price)