Re: Subselect in 4.0.12-max with --new option / Max Date

2003-07-23 Thread Michael Satterwhite
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tuesday 22 July 2003 22:28, [EMAIL PROTECTED] wrote: > Sorry I completely forget the query: > SELECT * FROM Kardex WHERE Fecha IN (SELECT maxfecha FROM fechas) > P.D. Im using 4.1 alpha version for win32 OK, something is still missing. I went to

RE: Subselect in 4.0.12-max with --new option / Max Date

2003-07-22 Thread mysql
- 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: >

Re: Subselect in 4.0.12-max with --new option / Max Date

2003-07-22 Thread Michael Satterwhite
-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 optio

RE: Subselect in 4.0.12-max with --new option / Max Date

2003-07-21 Thread Paul DuBois
At 1:04 -0400 7/22/03, [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 m

RE: Subselect in 4.0.12-max with --new option / Max Date

2003-07-21 Thread mysql
feature? I missing something about the conf?? maybe my.ini?? -Original Message- From: Michael Satterwhite [mailto:[EMAIL PROTECTED] Sent: Lunes, 21 de Julio de 2003 10:54 p.m. To: [EMAIL PROTECTED] Subject: Re: Subselect in 4.0.12-max with --new option / Max Date -BEGIN PGP SIGNED MESSAGE

Re: Subselect in 4.0.12-max with --new option / Max Date

2003-07-21 Thread Michael Satterwhite
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Monday 21 July 2003 18:48, [EMAIL PROTECTED] wrote: > Cod Product date > 10Nissan Car 2003-06-20 > 20Guitar Yamaha 2003-07-01 > 10Nissan Car 2003-05-01 > 30Stereo Cables 2003-01-20 > 20Gui

RE: Subselect in 4.0.12-max with --new option / Max Date

2003-07-21 Thread mysql
product, MAX(date) FROM table GROUP BY cod And other combination using the HAVING syntax. Please help!! -Original Message- From: Michael Satterwhite [mailto:[EMAIL PROTECTED] Sent: Sábado, 19 de Julio de 2003 08:36 p.m. To: [EMAIL PROTECTED] Subject: Re: Subselect in 4.0.12-max with --new

Re: Subselect in 4.0.12-max with --new option

2003-07-21 Thread Victoria Reznichenko
[EMAIL PROTECTED] wrote: > > I was reading the manual and it said that the subselect is only > available in 4.1 or using the 4.0.12 with the mysqld ?new command line > to start it. > > But it doesn?t working!! So I downloaded the 4.1 alpha version with the > same problem. The error is: > > ERROR

Re: Subselect in 4.0.12-max with --new option

2003-07-19 Thread Michael Satterwhite
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Friday 18 July 2003 21:28, [EMAIL PROTECTED] wrote: > ERROR 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 …. > > Any ideas? I need subselect working.

Subselect in 4.0.12-max with --new option

2003-07-19 Thread limbert
Hi, I was reading the manual and it said that the subselect is only available in 4.1 or using the 4.0.12 with the mysqld –new command line to start it. But it doesn’t working!! So I downloaded the 4.1 alpha version with the same problem. The error is: ERROR 1064: You have an error in your SQL