Post reply

select ..insert

  • June 10, 2008 at 9:56 pm

    #122595

    Hi Experts,

    Is it possible to insert a select statement directly to a table.

    TIA:)

  • June 10, 2008 at 10:13 pm

    #827054

    Certainly is...

    INSERT INTO Table2 (columnlist1)

    SELECT columnlist2 from Table1

    The names of the columns does not need to match but you do need to have the right number of columns.

  • June 13, 2008 at 4:25 am

    #828347

    insert into tablename select * from tablename

  • June 13, 2008 at 5:46 am

    #828398

    You can also use this method, which creates the table

    select *

    into {new tablename}

    from {old tablename}

    Wilfred
    The best things in life are the simple things

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

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