emb978@leah.Albany.Edu (Eric M. Boehm) (04/28/89)
I cannot seem to accomplish a set minus operation in SQL under VAX/VMS
5.0 without crashing SQL or generating bug check dumps
Essentially, I want to select all tuples in set 1 but not also in set 2.
For example, I want:
SELECT S_ID, SW_ID
FROM TEMP1
WHERE ((S_ID,SW_ID) IN (SELECT S_ID, SW_ID FROM TEMP2)) AND
((S_ID,SW_ID) NOT IN (SELECT S_ID, SW_ID FROM TEMP3));
However, SQL will not allow something like (S_ID,SW_ID). It complains
that I have two many columns in the value expression for IN (it seems
SQL will only allow a single column before the IN). Can set minus be
accomplished in SQL under VAX/VMS? If so, could someone please tell me how?
Thanks in advance - please reply via e-mail.
Eric M. Boehm
EMB978@ALBNYVMS.BITNET
EMB978@LEAH.ALBANY.EDU