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, 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, > 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 work. But it does not, and sets the Value > fields to incorrect values. > > update main set Value = (select SubValue from sub where main.ID = > sub.mainID order by KeyDate desc limit 1) > > Any ideas? > > Thanks, > Dan > > > > -- > MySQL Bugs Mailing List > For list archives: http://lists.mysql.com/bugs > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]