7.sql

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

SELECT memno,fname,lname
FROM member m
WHERE NOT EXISTS (
    SELECT DISTINCT borrowermemno 
    FROM book b
    WHERE m.memno = b.borrowermemno
    );