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
No problem, this is: Kardex Table: +---+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-+---+ | Nro | bigint(20) | | PRI | 0 | | | Fecha