Results 1 to 6 of 6

Thread: help with query

  1. #1
    Join Date
    Mar 2004
    Posts
    25

    Unanswered: help with query

    i am using the following query to seklect recordsf from one table to other table but the thing is it is creating a new table with the data but i just want to keep the data in the new table because the other table has some more fields and i will enter data in it later any help to solve is appreciated

    SELECT LNAME, FNAME, ID, ENROLL_HRS, TEST.LEVEL INTO MEDICAL
    FROM TEST
    WHERE (((TEST.ENROLL_HRS)<9) AND ((TEST.LEVEL)="G")) OR (((TEST.ENROLL_HRS)<12) AND ((TEST.LEVEL)="U"));

  2. #2
    Join Date
    Apr 2004
    Posts
    182
    Are you trying to seleect records or insert records into a new table - it is not clear .

  3. #3
    Join Date
    Mar 2004
    Posts
    25
    i am tryin to seelct records satisfying the condition and insert into new table

  4. #4
    Join Date
    Mar 2004
    Location
    Nashville, TN
    Posts
    557
    Might I ask what your purpose is for duplicating the data? I may have a suggestion for another route.

    JS
    Have you ever thought about thinking on purpose?

    Jarvis Stubblefield
    Patriot Designs
    Web/Database Development and Consulting
    The-Patriot.net by Patriot Designs

  5. #5
    Join Date
    Mar 2004
    Posts
    25
    ITS NOT DUPLICATING its creating a new table with some different fields in it and i an trying to get the values of the fields which are in common.

  6. #6
    Join Date
    Mar 2004
    Location
    Nashville, TN
    Posts
    557
    Sorry to have bothered you. I have can help no further on this matter.

    JS
    Have you ever thought about thinking on purpose?

    Jarvis Stubblefield
    Patriot Designs
    Web/Database Development and Consulting
    The-Patriot.net by Patriot Designs

Posting Permissions

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