part3.txt

来自「answer to sd7 Exercise1」· 文本 代码 · 共 15 行

( SELECT   MemNo
                  FROM     MEMBER, BOOK
                  WHERE    MemNo = BorrowerMemNo AND
                  CallNumber = 'QA76.9.D26C66'
                )
EXCEPT
( SELECT   MemNo 
  FROM     MEMBER, BOOK
  WHERE    MemNo = BorrowerMemNo AND
  CallNumber = 'QA76.9.D7E53'
);



The result is a list of member numbers of the members only borrow the book that has the call number QA76.9.D26C66 but not borrow the book that has the call number QA76.9.D7E53.