quary2.sql

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

SELECT name as "TITLE" 
FROM title
where callnumber IN
		(
		 SELECT callnumber
		 FROM book
		 WHERE borrowermemno IN
				(
				 SELECT memno
				 FROM member
				 WHERE fname = 'John' OR fname = 'Susan'
				)
		)