Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!zaphod.mps.ohio-state.edu!mips!wrdis01!news.cs.indiana.edu!ux1.cso.uiuc.edu!midway!mimsy!nocusuhs!yoshi
From: yoshi@nocusuhs.nnmc.navy.mil (Dojun Yoshikami)
Newsgroups: comp.databases
Subject: Re: SQL Differences Question
Keywords: set differences, SQL
Message-ID: <1991Apr17.205747.27449@nocusuhs.nnmc.navy.mil>
Date: 17 Apr 91 20:57:47 GMT
References: <1991Apr17.133725.25499@nocusuhs.nnmc.navy.mil>
Organization: National Naval Medical Center
Lines: 28

In article <1991Apr17.133725.25499@nocusuhs.nnmc.navy.mil> yoshi@nocusuhs.nnmc.navy.mil (Dojun Yoshikami) writes:
>
>Question for all you SQL'er's,
>
>How can one get the difference between two sets?  I have two tables (s, and t)


My heartfelt thanks to all those who replied to my request.   I believe I've
been a little remiss (my last message didn't have enough information).  
Anyways,

I found to my dismay that the SQL implementation (in this case, INGRES 6.1) 
seems to lack the MINUS operator for subqueries!!   Arrgh!!!!!  (No, you don't
have to put your flame suit on...!).  Anyways, there's probably a workaround
somewhere, or something to that effect... or I'll be rather upset!  While
we're on the subject, did anyone else run into a similar SQL gotcha in INGRES
of this kind (or any other kind) that normally appears in SQL but is 
mysteriously absent?  Or is there a way to do the same thing in QUEL?
[My boss will kill me if I do anything in Quel, but if there's a will, there's
a way!]
 
DY ;-)

=-=-=-=-=-=-=-=-=-=-=-=-=-=+=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
D M Yoshikami  :-) ;-) :-) | Internet: yoshikami@usuhsb.ucc.usuhs.nnmc.navy.mil
May the Forth be with you! | Bitnet  : yoshikami@usuhsb.bitnet
***  !!xob X*NU V METSYS T&TA eht ni renosirp dleh gnieb m`I  !pleH  !pleH  ***
=-=-=-=-=-=-=-=-=-=-=-=-=-=+=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=