Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Location
    KY
    Posts
    56

    Unhappy Unanswered: Help with Insert Statement!!!!!!!!!

    Can somebody help me with an Insert statement. I'm trying to insert data from one table into another table.
    My structure that i wrote isn't working at all.

    Please Help

  2. #2
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    if both tables have the same structure:
    insert into Another_Table
    select * from One_Table

    if you wish to only insert data from a few attributes:
    insert into Another_Table (First, Last, Middle)
    select FirstName, LastName, MiddleName from One_Table

    Of course you can add a where clause when needed
    Paul Young
    (Knowledge is power! Get some!)

Posting Permissions

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