Member Avatar for 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 ?

  • 2 Contributors
  • 1 Reply
  • 66 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by darkagn
Member Avatar for 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 :)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.