📄 ex2-3.sql

📁 数据库系统练习答案

💻 SQL

字号:

select "fname","lname","memno"
from "member"
where "memno" IN (select "borrowermemno"
		  from "title" NATURAL JOIN "book"
		  where "name" = 'Odyssey') 
INTERSECT 
select "fname","lname","memno"
from "member"
where "memno" IN (select "borrowermemno"
		  from "title" NATURAL JOIN "book"
		  where "name" = 'Iliad')

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -