8.sql

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

SELECT fname
FROM member
WHERE phonenumber LIKE '412%' 
AND memno NOT IN (
    SELECT b.borrowermemno
    FROM book b,title t
    WHERE b.callnumber = t.callnumber and t.name='Pitt Roads'
)
ORDER BY fname
;