Bulk copy data

Dear All,
Can anyone tell me what's the best/easiest way to copy one column of data from one table to another column of another table.
Thanks in advance.Do the tow tables have relationships?
If they have ralationships,so u can do by update statement.
eg,
update table1 set col2=table2.col2
FROM table2 WHERE table1.col1=table2.col1|||:confused: What if they don't have relationships?

Do the tow tables have relationships?
If they have ralationships,so u can do by update statement.
eg,
update table1 set col2=table2.col2
FROM table2 WHERE table1.col1=table2.col1|||Could you explain a little more what you are trying to do...
...it doesn't sound like a good idea to insert data into a table that has no relations to the data that already exsists!?