ex2-2.sql

数据库系统练习答案

select DISTINCT "name"
from "book" NATURAL JOIN "title","member"
where "borrowermemno"  IN (select "memno"
			  from "member"
			  where "fname" = 'Susan' OR "fname" = 'John')