quary5.sql

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

SELECT phonenumber
FROM member	
WHERE memno IN	 
	(
	 SELECT borrowermemno 
	 FROM book
	 WHERE callnumber IN
			 (
			  SELECT callnumber
			  FROM author
			  WHERE lname = 'Tanenbaum'
			 )
	)