Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Location
    NH
    Posts
    87

    Unanswered: MS Access 2002 SQL

    Is there a set operator in MS Access 2002 with the equivelent functionality of the MINUS operator in Oracle?

    I'm pulling my hair out trying to figure out a way to run a query without the MINUS operator; rather difficult.

    table_all - 1000 rows
    table_some - 800 rows
    table_bogus - 100 rows

    I can't get the last 100 rows that I need.... is that too vague?

    -Thanks!
    Warren

  2. #2
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778
    1)
    Select top 100
    from tableA
    order by column DESC

    2)
    select *
    from
    (select top 200 *
    from tableA
    order by column) V
    where V.key NOT IN
    (select top 100 key order by column)
    Last edited by r123456; 07-15-04 at 10:50.
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

  3. #3
    Join Date
    May 2004
    Location
    NH
    Posts
    87
    AHH I figured it out... LEFT JOIN on table where value is NULL! Thanks for your reply.

Posting Permissions

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