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_at_comcast.com>
Date: Tue, 31 Aug 2004 10:41:47 -0400
Message-ID: <4_ednRFhuu85EKncRVn-rQ_at_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 - 16:41:47 CEST