assume you do by the
requirment for the most recent item). Maybe I'm really off :(
Regards,
A$
- Original Message -
From: Mark Hedges <[EMAIL PROTECTED]>
Date: Monday, August 4, 2003 11:16 am
Subject: Re: SubQuery bug in 4.1
> Surely this will just work?
>
> up
Your primary query has no where clause, so you are setting all Value to
a value from a random record for the most recent date.
Hardly looks like a 'bug' to me.
And why the cross post?
Daniel Kiss wrote:
Hi all,
I have two tables
CREATE TABLE main (
ID int not null,
Value int
);
CREATE TAB
Surely this will just work?
update main,sub set main.Value = sub.subValue where main.id=sub.mainid;
Or have I misunderstood what you are wanting?
--
Mark
- Original Message -
From: "Daniel Kiss" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, August 04, 20
Daniel Kiss writes:
> Hi all,
>
> I have two tables
>
>
> CREATE TABLE main (
>ID int not null,
>Value int
> );
>
> CREATE TABLE sub (
>mainID int not null,
>KeyDate date not null,
>SubValue int not null
> );
>
>
> I want the Value field in the main table to be set to the
