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