Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    24

    Unanswered: Difference of two select statements

    Hi All,

    I want to find difference of two Select statement in SQL Server 2000. As in Oracle we have "MINUS". Do we have the same thing in SQL Server also.

    Thanks with Regards.

    -Mohit.

  2. #2
    Join Date
    Oct 2003
    Posts
    84
    I'm not sure about how MINUS in oracle works...but I gues you can use the WHERE X NOT IN ... or WHERE NOT EXISTS(SELECT...) constructs to achieve what you need.

  3. #3
    Join Date
    Sep 2003
    Location
    Dallas, Texas
    Posts
    311
    I believe that is same as doing the left outer join in SQL.

Posting Permissions

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