-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
-
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:
>
-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
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
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
-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
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
[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
-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.
