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不能用。
解决方案 »
- 帮忙看下一个数据库性能问题
- 求一条简单SQL语句!
- 求一sql,统计一个表中某一列含有重复的记录总数
- 发现了mysql某些ENGINE下不能rollback事务(已经设置了setAutoCommit(false); )
- 问个MYSQL问题 错误:Data truncated for column 's' at row 1
- Sql数据库同步复制求助...............
- 关于主键设计的疑惑
- 存入mysql数据库
- mysql query broswer生成的数据库存在哪里了?
- 求教大佬,想查询不以某串数字加一段字符串结尾的记录,sql怎么写?
- 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'));