locked
Minus Columns RRS feed

  • Question

  • Hi all,

    I have two queries which are the same but the only difference is the where clause.

    I need to minus the fields from one query from another. what is the best way to do this?

    Monday, August 16, 2010 1:16 PM

Answers

  • SELECT * FROM QUERY1

    EXCEPT

    SELECT * FROM QUERY2


    Regards, Deven ----------------------------------------- Please vote if you find any of my post helpful.
    • Proposed as answer by Naomi N Monday, August 16, 2010 1:28 PM
    • Marked as answer by Ai-hua Qiu Monday, August 23, 2010 9:00 AM
    Monday, August 16, 2010 1:19 PM