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