Topic awaiting preservation: Minus & Intersect — OZONE Asylum, home of the Mad Scientists

This page's ID: 23239

Topic awaiting preservation: Minus & Intersect (Page 1 of 1) $Pages that link to <a href="https://ozoneasylum.com/backlink?for=23239" title="Pages that link to Topic awaiting preservation: Minus &amp; Intersect (Page 1 of 1)" rel="nofollow" >Topic awaiting preservation: Minus & Intersect <span class="small">(Page 1 of 1)</span>\$

Tekapo Nervous Wreck (II) Inmate From: Insane since: Aug 2004	posted 09-09-2004 10:52 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.
Tyberius Prime Paranoid (IV) Mad Scientist with Finglongers From: Germany Insane since: Sep 2001	posted 09-09-2004 17:49 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,
Tekapo Nervous Wreck (II) Inmate From: Insane since: Aug 2004	posted 09-10-2004 04:34 Hi, thanks for your reply. I just wanted to know if there is a way without using sub query. Thanks for your help.

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