• Phil & Sean both are right but you can use something like this..

    Insert into Table2 (col3)

    Select col1 + ' ' + col2 from table1