INSERT columns

[cVz]

Hey hey

I have two tables with a lot of data, i need to insert certain column values from table one into table two - eg

Table one column = First_Name
Table two column = Name

I need to get all the values in table one (First_Name) into table two (Name), these records should be appended..

Any help would really be appreciated ?

[darkagn]

Something like this should work:

-- set where to insert
INSERT INTO Table_one (First_Name) 
-- select values to insert
SELECT Name FROM Table_Two
-- you may need to specify which ones from Table_two to insert
-- using a WHERE clause

HTH :)