Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2004
    Posts
    2

    Unanswered: Complicated Insert Statement

    Hello,

    I have a question. I have two tables tableOne has a fields bug_id and resolution. TableTwo has fields bug_id, version_type, and version.

    I need to create an insert statement that inserts the tableOne.bug_id into tabletwo.bug_id where tableOne.resolution='DOCUMENTED'.

    Can someone please show me how to do this?

    Thanks!

  2. #2
    Join Date
    Aug 2004
    Location
    France
    Posts
    754
    Hello,

    Well, it is almost as you have written it :
    Code:
    Insert into tabletwo(bug_id) 
    select bug_id 
    from tableone 
    where resolution='DOCUMENTED';
    Regards,

    RBARAER

  3. #3
    Join Date
    Oct 2004
    Posts
    2
    Thanks, that did exaclty what I wanted. I have never used an insert statement like that before.

Posting Permissions

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