Post reply

copy data from one table to another table with different fields

  • 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.

     

  • 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.
    ******************

  • August 29, 2006 at 12:04 pm

    #657328

    Thanks

    Have a nic e day.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply