quary5.sql

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

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