-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.
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 doesnt 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
10 matches
Mail list logo