Re: NESTED QUERY in MySQL 4.3.3
Sinisa Milivojevic <[email protected]>
| Newsgroups | gmane.comp.db.mysql.bugs |
|---|---|
| Message-ID | <[email protected]> |
Alberto writes: > 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 > > > Any suggestion? > > Thanks, > Albert > Sorry, we do not have version 4.3.3. Please report back a correct version -- Sincerely, -- For technical support contracts, go to https://order.mysql.com/?ref=msmi __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[email protected]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB /_/ /_/\_, /___/\___\_\___/ Full time Developer and Support Coordinator <___/ www.mysql.com Larnaca, Cyprus Meet the MySQL at User Conference ! (April 14-16, 2004) http://www.mysql.com/uc2004/ -- MySQL Bugs Mailing List For list archives: http://lists.mysql.com/bugs To unsubscribe: http://lists.mysql.com/[email protected]