Anyone Know MS SQL?

[funkyol]

I've got 2 tables (OldTable and NewTable for examples sake) and want to import the data from one field (Full_Name) in one table, into a field in another table.

I would have thought the following code:

INSERT INTO NewTable (Full_Name) SELECT Full_Name FROM OldTable

Would work, but it doesn't.

I'm still learning the SQL syntax etc, anyone able to lend a hand?

[mike_obuk]

im learning that at the moment! but i havent been payin attention in lectures so im afraid i cant help ya! wich i did know tho coz ive gott start a coursework assignment on it 2m!