Re: NESTED QUERY in MySQL 4.3.3
Sanja Byelkin <[email protected]>
| Newsgroups | gmane.comp.db.mysql.bugs |
|---|---|
| Message-ID | <[email protected]> |
Hi! On Sat, Feb 28, 2004 at 09:23:46PM +0100, Alberto wrote: > Hi to all, i've installed the MySQL 4.3.3 and a nested query don't work... > > The query is: > > SELECT ID FROM USER_ACCESS WHERE MOMENT = (SELECT MAX(MOMENT) FROM > USER_ACCESS) > > The query is very similar to the example i've found in the online > documentation at the address > http://www.mysql.com/doc/en/Comparisons_using_subqueries.html > > The error reported is: > > You have an error in your SQL syntax. Check the manual that corresponds to > your MySQL server version for the right syntax to use near 'SELECT > MAX(MOMENT) FROM USER_ACCESS)' at line 1 It looks like version less then 4.1, where subqueries is not supported. -- Want to swim with the dolphins? (April 14-16, 2004) http://www.mysql.com/uc2004/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Oleksandr Byelkin <[email protected]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Lugansk, Ukraine <___/ www.mysql.com -- MySQL Bugs Mailing List For list archives: http://lists.mysql.com/bugs To unsubscribe: http://lists.mysql.com/[email protected]