quary7.sql

来自「数据库查询语言,便于新手的使用」· SQL 代码 · 共 6 行

SELECT information.fname as "First Name", information.lname as "Last Name",information.memno AS "ID"
FROM (
	SELECT fname , lname, memno,callnumber
		FROM member LEFT OUTER JOIN book ON (member.memno = book.borrowermemno)
) AS information
WHERE information.callnumber IS NULL;