Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!rip!news.webusenet.com!feed1.newsreader.com!newsreader.com!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews1.google.com!not-for-mail
From: dangerousminds_17@yahoo.com (Sumanth Suri)
Newsgroups: comp.databases.ms-sqlserver,comp.databases.oracle
Subject: minus and intersect functionality
Date: 11 Nov 2003 14:14:55 -0800
Organization: http://groups.google.com
Lines: 18
Message-ID: <2e121621.0311111414.69cc4a0b@posting.google.com>
NNTP-Posting-Host: 64.115.249.92
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1068588895 6778 127.0.0.1 (11 Nov 2003 22:14:55 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 11 Nov 2003 22:14:55 +0000 (UTC)
Xref: newssvr20.news.prodigy.com comp.databases.ms-sqlserver:105337 comp.databases.oracle:23271

Hi,
   I've used the minus functionality which is available in Oracle and
i would like to use it in SQL server, but i don't know how to. The
folllowing is how it works in Oracle

Select symbols from symbol_table
minus
select tsymbols from trade

It returns a list of all the symbols from symbol_table which are not
present in trade.
Similarly, the intersect will return only those which are common to
both.

I was wondering if someone throw some light on this problem for me.

Thanks in advance,
Sumanth