看看这个语句出错？？

熊心搏搏

MYSQL中：
SELECT categories_id
FROM products_to_categories
WHERE categories_id IN (SELECT categories_id
FROM categories
WHERE categories_id = '1'
OR PARENT_id = '1')

#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT categories_id
FROM categories
WHERE categories_id = '1

welbird

mysql旧版本好像不支持 子查询

odin_free

[quote]原帖由 "welbird"]mysql旧版本好像不支持 子查询[/quote 发表：

stonex

个人觉得可以分成两个查询语句来做