I have two different tables both have the same userID and number of records.
In table2 I have a column name comments and table1 I have a column named custom_1.
the field comments in table2 is empty and I want to transfer data from table1.custom_1 to table2.comments.
I tried using the UPDATE statement but with no success.
Is there away to do this?
yes, there is a way, you need to be on 4.0.something
I figured out another way of doing it. I created a new table with the same structure as table2.
Then did an insert statment with a select statement joinging table1&table2.
This gave me the fields I am looking for from both tables :)