ex2-7.sql

数据库系统练习答案

select *
from "member"
where "memno" IN
	(select "memno"
	from "member"
	EXCEPT 
	(select  "borrowermemno" 
	from "book"
	where "borrowermemno" IS NOT NULL))