What I am trying to do in MySQL. Table1
UserID ProductID Old_UserID 1 2 4 2 3 5 Table2 UserID ProductID 4 Null 5 Null Table1 has new correct data. Table2 has old incorrect data. The link is Table2.UserID and Old_UserID What I need to do is update Table 2 with the new data from Table 1, But I can not get this to work..e.g. UPDATE Table2.ProductID SET Table2.ProductID = Table1.ProductID WHERE Table1.Old_UserID = Table2.UserID REPLACE will not work as these are not KEY fields. Once I have done the ProductID I should then be able to do the UserID using the ProductID (as all values in one table are unique). Help Simon --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
