8.sql

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

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
;