SELECT memno, fname, lname
FROM member
WHERE memno IN
(SELECT borrowermemno
FROM book
WHERE callnumber IN
(SELECT callnumber
FROM title
WHERE name = 'Iliad'))
INTERSECT
SELECT memno, fname, lname
FROM member
WHERE memno IN
(SELECT borrowermemno
FROM book
WHERE callnumber IN
(SELECT callnumber
FROM title
WHERE name = 'Odyssey'));
请问这个在mysql中要怎么实现?似乎INTERSECT不能用。
FROM member
WHERE memno IN
(SELECT borrowermemno
FROM book
WHERE callnumber IN
(SELECT callnumber
FROM title
WHERE name = 'Iliad'))
INTERSECT
SELECT memno, fname, lname
FROM member
WHERE memno IN
(SELECT borrowermemno
FROM book
WHERE callnumber IN
(SELECT callnumber
FROM title
WHERE name = 'Odyssey'));
请问这个在mysql中要怎么实现?似乎INTERSECT不能用。
解决方案 »
- case语句可以这样用么?求解
- 请问如何利用mysql对实验记录数据进行管理
- tomcat自动加载更新的类文件之后,发现mysql的数据库连接新增了c3p0连接池的connection
- 请教一个mysql方面的问题:怎样将序号写入表中的整型字段 ?
- ERROR [HY000] [MySQL][ODBC 3.51 Driver]Lost connection to MySQL server during qu
- 重新编译mysql的时候能不能不停止mysql?
- 关于MYSQL逐行操作的问题
- MySql可不可以进行可视化操作?来者有分
- 在一个表查询一个含有特定字符串的字段的sql语句
- mysql是否支持双CPU
- ERROR 1044 求助~
- handlersocket无法安装在二进制版本mysql下面吗?
我换成inner jion还是不行。。
FROM member
WHERE memno IN
(SELECT borrowermemno
FROM book
WHERE callnumber IN
(SELECT callnumber
FROM title
WHERE name = 'Iliad'))
and memno IN
(SELECT borrowermemno
FROM book
WHERE callnumber IN
(SELECT callnumber
FROM title
WHERE name = 'Odyssey'));