Post reply

Getting select records from one tabel to another

  • May 22, 2007 at 2:25 pm

    #371355

    I have 3 tables which design wise are set up the same.  The data is different.

    I set up a query to compare records in 2 of the tables and there are about 30,000 records which are missing from one table.  I want to take these 30,000 records and add them into the 3rd table.  What would be the fastest and most effective way to do so?  I am not an experienced in SQL queries so please help the best you can.

    Thanks.

  • May 22, 2007 at 2:40 pm

    #708189

    INSERT INTO Table3 (<column list&gt

    SELECT <your select that you used to identify the 30,000 missing rows>

    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