7.sql

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

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