ex2-4.sql

来自「数据库系统练习答案」· SQL 代码 · 共 11 行

select "memno","fname","lname"
from "member"
where NOT EXISTS
(SELECT *
from (select "callnumber"
      from "author"
      where "lname" = 'Collins') AS "Course"
where NOT EXISTS
(select *
from "book" 
where "callnumber" = "Course"."callnumber" AND "borrowermemno" = "member"."memno"));