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.
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
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
