minus and intersect functionality

   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 Received on Tue Nov 11 2003 - 23:14:55 CET