Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2007

    Unanswered: SQL Query - Insert data from one table into the other

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


  2. #2
    Join Date
    May 2005
    Nevada, USA
    Provided Answers: 6
    How about

    INSERT INTO tblB(Field1, Field2,...)
    SELECT Field1, Field2,...
    FROM tbla

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts