Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Minus/intersect

2 posts in Product Futures Discussion Last posting was on 2003-05-22 03:26:27.0Z
MattR Posted on 2003-05-21 19:09:08.0Z
Message-ID: <2907645.1053544148@dbforums.com>
Subject: Minus/intersect
From: MattR <member8@dbforums.com>
Organization: dBforums
Date: Wed, 21 May 2003 19:09:08 +0000
Sender: MattR
User-Agent: dBforums
X-Original-NNTP-Posting-Host: dbforums.com
X-Original-Trace: 21 May 2003 15:34:35 -0400, dbforums.com
Lines: 15
X-Authenticated-User: paul
Newsgroups: sybase.public.ase.product_futures_discussion
NNTP-Posting-Host: news.usenetgateway.com 66.33.57.44
Path: forums-1-dub!forums-master.sybase.com!forums-1-dub.sybase.com!news.usenetgateway.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1229
Article PK: 95468

Any way we could see the MINUS/INTERSECT relational operators
implemented in T-SQL?

I know I can do the same thing using existential operator (NOT)EXISTS
but it is a heck of a lot more clear to use the relational operators
(and I'm less likely to mess it up as well).

Thanks,

--
Matt

--
Posted via http://dbforums.com


Bret Halford Posted on 2003-05-22 03:26:27.0Z
Message-ID: <3ECC4363.9ADEE04@sybase.com>
Date: Wed, 21 May 2003 21:26:27 -0600
From: Bret Halford <bret@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.76 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Minus/intersect
References: <2907645.1053544148@dbforums.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.ase.product_futures_discussion
NNTP-Posting-Host: vpn-dub-049.sybase.com 10.22.120.49
Lines: 10
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1230
Article PK: 95467


MattR wrote:
>
> Any way we could see the MINUS/INTERSECT relational operators
> implemented in T-SQL?
>
> I know I can do the same thing using existential operator (NOT)EXISTS
> but it is a heck of a lot more clear to use the relational operators
> (and I'm less likely to mess it up as well).
>

There is an open feature request for this, CR 298441.

-bret