mysql难道不支持嵌套查询?
这样一个语句总是报语法错误
SELECT Price
FROM Books
WHERE Books.Publisher_Id = (SELECT Publisher_Id FROM Publishers WHERE Name = 'Corlis')
单独使用
SELECT Publisher_Id FROM Publishers WHERE Name = 'Corlis'
和
SELECT Price
FROM Books
WHERE Books.Publisher_Id = 18835
都没有错误
难道 mysql不能用嵌套查询?还是有其他错误?
我用的mysql版本是 4.0.12 for windows