RE: subquery help for an update

2005-02-16 Thread mel list_php
e. So if anybody has a link to a doc for subqueries? From: "mel list_php" <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Subject: subquery help for an update Date: Wed, 16 Feb 2005 14:32:48 + Hi, I have one table tableNames ID,name, new_name. The columns ID and name are popul

subquery help for an update

2005-02-16 Thread mel list_php
Hi, I have one table tableNames ID,name, new_name. The columns ID and name are populated. I would like to update the field new_name from an other table tempName (ID,nameUpdated). The ID between the 2 tables are the same, but I don't have the info for all the ID. (so 568 rows in my first table on