! Please! :)
Roy
-Original Message-
From: Rudy Metzger [mailto:[EMAIL PROTECTED]
Sent: Monday, July 14, 2003 3:49 AM
To: Roy Walker; [EMAIL PROTECTED]
Subject: RE: Complex select statement
I never heard before that you can use a select statement in an arithmetic expression.
Only ALL, ANY, MIN
To: [EMAIL PROTECTED]
Subject: Re: Complex select statement
As far as I know, MAX only returns the greatest row, so what you really
want at the end is
WHERE table_tmp.id=table2.id AND table2.timestamp=MAX(table2.timestamp)
~MJI
Roy Walker wrote:
Still having a problem with this. Still have
for the 'SELECT count FROM table2 WHERE id=id1' section.
Is this illegal syntax? Would this be considered a subselect?
Thanx,
Roy
-Original Message-
From: Paracková Eva, Ing [mailto:[EMAIL PROTECTED]
Sent: Friday, July 11, 2003 12:30 AM
To: Roy Walker
Subject: RE: Complex select
PROTECTED]
Sent: Friday, July 11, 2003 11:52 AM
To: [EMAIL PROTECTED]
Subject: Re: Complex select statement
Roy Walker [EMAIL PROTECTED] wrote:
Thanx for your help. Still having an issue with this. I forgot to
mention I am running MySQL 4.0.13. Tried both of these statements:
INSERT
If anyone could tell me what I am doing wrong here, I would greatly appreaciate it.
Have the following tables:
table1: id, count
table2: id, count, period_count, date, timestamp
Trying to do the following; get all rows from table 1 and insert them into table2
while setting period_count to