Post reply

SQL Query - Insert data from one table into the other

  • October 12, 2007 at 4:03 pm

    #178937

    OK, this one should be easy for you folks but my mind is drawing a blank.

    Can someone give me an example query to copy data from one table to another? Both tables already exist and both tables have the same table definition. tblA has data tblB is completely empty. I just want to copy from tblA into tblB.

    I dont want to use the GUI, nor do I want to do a "Select * Into..."

    Thanks

  • October 12, 2007 at 4:22 pm

    #741746

    INSERT INTO TableA

    SELECT * FROM TableB

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

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

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