Selecting from one table to UPDATE another.

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

Re: Selecting from one table to UPDATE another.

Hello! Simon Green wrote: 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