Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: How to do a difference on two sets from same table?

Re: How to do a difference on two sets from same table?

From: Laconic2 <laconic2_at_comcast.net>
Date: Tue, 31 Aug 2004 10:41:47 -0400
Message-ID: <4_ednRFhuu85EKncRVn-rQ@comcast.com> 






"Dan" <dan_at_nospam.com> wrote in message


news:Bw%Yc.5$2A3.984_at_news.uswest.net...


> Alas, my BRIO sql query tool (using odbc against ms sql server) does not

> support MINUS or EXCEPT.




Does BRIO support WHERE NOT EXISTS (correlated_subquery)?




If so, it may be possible to generate the same result as a MINUS.  But I
admit I haven't tried to apply this technique to your OP.
Received on Tue Aug 31 2004 - 09:41:47 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US