3.sql

ssd7数据库的联系一到练习三

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');