Topic awaiting preservation: Minus & Intersect (Page 1 of 1)

Hi, guys. I just read SQL book.
It was saying about Minus & Intersect things.
They are supported by Oracle but not MS SQL server, right?
I just wonder how you write for SQL server to do get same result.
Thanks.

hm..
I suppose you could easily fake minus with a sub query (and id not in (select id where RowsThatShouldNotAppearInResult).
And though I've never worked with either of them, intersect seems to be easily resolved with such a sub query as well (though I don't see why you can't just combine your queries into one where statement. But then, I've never tinkered with advanced SQL).

so long,

Hi, thanks for your reply.
I just wanted to know if there is a way without using sub query.
Thanks for your help.