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
>
Sent: Monday, August 04, 2003 4:09 PM
Subject: SubQuery bug in 4.1
> 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,
>Sub
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
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 latest SubValue
in the sub table.
I suppose this syntax should w
