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