copy data from one table to another table with different fields

• rs-337036

  Ten Centuries

  Points: 1105

  More actions

  August 29, 2006 at 10:36 am

  #173793

  I need to copy data from one table to another table. But the 2 table do not have all the same fields as the 1st table.

  For example

  1 Table has

  id

  First name

  last name

  Address

  City

  Zip

  2 Table has

  id

  First Name

  Last Name

  Zip

  I need to copy First name , last name and zip from the first table to the second table. How do i do that.

   

• Dinakar Nethi-176633

  SSCarpal Tunnel

  Points: 4689

  More actions

  August 29, 2006 at 11:31 am

  #657318

  you could do an

  INSERT INTO table1( col1, col2, col3)

  SELECT col1, col2, col3

  FROM table2

  ******************
  Dinakar Nethi
  Life is short. Enjoy it.
  ******************

• rs-337036

  Ten Centuries

  Points: 1105

  More actions

  August 29, 2006 at 12:04 pm

  #657328

  Thanks

  Have a nic e day.