Post reply

Copy row with many columns

  • June 2, 2006 at 3:43 am

    #168393

    Hi,

    Is it possible to copy one single row from table1 to table2 by not explicitly naming the columns? So I would like to do something like:

    SELECT table1(*) VALUES(*) FROM table 2

    table1 and table2 have the exact same format

    Thanks,

    Erik

  • June 2, 2006 at 3:45 am

    #641370

    Of course I mean:

    INSERT table1(*) VALUES(*) FROM table 2

    Erik

  • June 2, 2006 at 4:08 am

    #641374

    try

    insert into <table 1)

    select * from <table 2>

    where <condition>

    Hope that helps

  • June 2, 2006 at 4:18 am

    #641375

    Hi,

    Just what I needed thanks!!

    Erik

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

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