Results 1 to 3 of 3
Thread: UPDATE syntax
May 9, 2004, 06:14 #1
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?
May 9, 2004, 17:04 #2
- Join Date
- Jul 2002
- Toronto, Canada
- 59 Post(s)
- 3 Thread(s)
May 9, 2004, 17:13 #3
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