3.sql

来自「ssd7的练习1」· SQL 代码 · 共 11 行

SELECT m.memno,m.fname,m.lname
FROM member m
WHERE m.memno in (
     SELECT b.borrowermemno
     FROM title t,book b
     WHERE t.callnumber=b.callnumber and t.name='Iliad') 
and
m.memno in (
     SELECT b.borrowermemno
     FROM title t,book b
     WHERE t.callnumber=b.callnumber and t.name='Odyssey');