Hi again, Sorry I completely forget the query: SELECT * FROM Kardex WHERE Fecha IN (SELECT maxfecha FROM fechas) This is really weird cause I try the same query in SQL form M$ and it work. Is a simple query and I know that can be rebuild with other query syntax but the question here is why it doesn’t working?
About the --new startup option for mysqld.exe (win32) you can found it here: http://www.mysql.com/doc/en/Prepare-upgrade-4.0-4.1.html Of course in the page say "critical changes" from the 4.1 version, so I am just guessing about the support of subselect in 4.0.12. Any way this are the field-structure of my table: Again thanks a lot for your help. P.D. Im using 4.1 alpha version for win32 Kardex Table: +---------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+-------------+------+-----+---------+-------+ | Nro | bigint(20) | | PRI | 0 | | | Fecha | datetime | YES | | NULL | | | CodProducto | bigint(20) | YES | | 0 | | | Ref | varchar(50) | YES | | NULL | | | Empresa | varchar(50) | YES | | NULL | | | Cant | double | YES | | 0 | | | Balance | double | YES | | 0 | | | BalanceLitros | varchar(50) | YES | | NULL | | | CantKilos | double | YES | | 0 | | | BalanceKilos | double | YES | | 0 | | +---------------+-------------+------+-----+---------+-------+ fechas table: +---------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+-------------+------+-----+---------+-------+ | Nro | bigint(20) | | PRI | 0 | | | maxfecha | datetime | YES | | NULL | | | CodProducto | bigint(20) | YES | | 0 | | +---------------+-------------+------+-----+---------+-------+ -----Original Message----- From: Michael Satterwhite [mailto:[EMAIL PROTECTED] Sent: Martes, 22 de Julio de 2003 06:05 a.m. To: [EMAIL PROTECTED] Subject: Re: Subselect in 4.0.12-max with --new option / Max Date -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Tuesday 22 July 2003 00:04, [EMAIL PROTECTED] wrote: > 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: > > 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?? I still haven't seen the query that has the error. Subselect does work in 4.1. If you'll post the query that has the error (and the the entire error message, the "near" is significant <g>) we'll be glad to help. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2-rc1-SuSE (GNU/Linux) iD8DBQE/HQxTjeziQOokQnARAp0xAJwOqpaWhSlXPNrpAz2bkRCfjFF2hQCeKB2C ZrZn9QuI3MPDbXcqY0RDFeI= =25tB -----END PGP SIGNATURE----- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
