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

    Unanswered: Help With SQL Statements

    Is there a way to write 2 SQL statements in one.
    I'm trying to make 2 criteria's do one job!!!!!!


    Help!!!!

  2. #2
    Join Date
    Nov 2002
    Location
    The Netherlands
    Posts
    61
    What are the 2 SQL statements then?

  3. #3
    Join Date
    Dec 2002
    Location
    KY
    Posts
    56
    ONe SQL would query Records 3yrs and older, and the other one would query the records with a year_type of 1. So any record with a year_type 1 and is 3yrs and older would be deleted from the archive table.

    Originally posted by DeathWing
    What are the 2 SQL statements then?

  4. #4
    Join Date
    Nov 2002
    Location
    The Netherlands
    Posts
    61
    Didnt that get answered in the other Topic or are we talking about something different?

  5. #5
    Join Date
    Dec 2002
    Location
    KY
    Posts
    56
    yeah the first part was answered and now i'm trying to incorporate this second part into the first part.


    QUOTE]Originally posted by DeathWing
    Didnt that get answered in the other Topic or are we talking about something different?
    [/QUOTE]

Posting Permissions

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