ex2-3.sql

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

select "fname","lname","memno"
from "member"
where "memno" IN (select "borrowermemno"
		  from "title" NATURAL JOIN "book"
		  where "name" = 'Odyssey') 
INTERSECT 
select "fname","lname","memno"
from "member"
where "memno" IN (select "borrowermemno"
		  from "title" NATURAL JOIN "book"
		  where "name" = 'Iliad')