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?