On Wed, April 25, 2007 23:10, Jørn Dahl-Stamnes wrote: > Please, I nedd help!! > > I have two tabels: > > table1: > id > value > > table2: > id > value > > Both tables has a lot of records with identical IDs. I need to update the > table1.value with the table2.value where the id are identical.
update table1 t1, table2 t2 set t1.value=t2.value where t1.id=t2.id; > > But I cannot find any UPDATE query that can do this in a single operation. > Anyone that can give me a suggestion? > > I'm using MySQL 4.1.8 > -- Later Mogens Melander +45 40 85 71 38 +66 870 133 224 -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]