quary7.sql

数据库查询语言,便于新手的使用

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;