ilto:[EMAIL PROTECTED]
Sent: Tuesday, July 15, 2003 4:27 PM
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 W
ow to do it 4.1! 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.
Onl
ge-
From: Egor Egorov [mailto:[EMAIL 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
ment
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
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 co
