quary1.sql

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

SELECT name as "TITLE", year as "YEAR"
FROM title
WHERE callnumber IN
		(
		 SELECT callnumber
		 FROM author
		 WHERE lname = 'Churchill'
		);