quary3.sql

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

SELECT fname as "First Name", lname as "Last Name", memno as "ID"
FROM member
WHERE memno IN
	(
	 SELECT borrowermemno
	 FROM book
	 WHERE callnumber IN
			 (
			  SELECT callnumber
			  FROM title
			  WHERE name = 'Iliad'
			 )
	 INTERSECT
	 SELECT borrowermemno
	 FROM book
	 WHERE callnumber IN
			 (
			  SELECT callnumber
			  FROM title
			  WHERE name = 'Odyssey'
			 )
	)