You are right above the max date query and I really appreciate your help, but the subselect query its other question. I try the subselect query with the 4.0.12-max win32 with the --new option in the command line to start the server, according to the manual this should enable the subselect feature, but it doesn’t, so I try with the 4.1 alpha win32 version with the same error:
I'm curious where you find it in the manual that --new turns on subselects in 4.0.12.
RROR 1064: 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............ and so on....
any ideas why I cant use the subselect feature? I missing something about the conf?? maybe my.ini??
Perhaps it's simply that your query is malformed. As far as I can tell, you haven't actually posted the query, so it's diffficult to tell.
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
