sql 子查询

Question

SELECT *
FROM web_infomation AS a
WHERE a.id
IN (

SELECT Id
FROM web_infomation_ty AS b
WHERE b.Pid =10
)
LIMIT 0 , 30

这上面的sql出错了 可是不知道原因在那里 大家帮忙看看

Answer 1

嗯，mysql4.1以上版本才支持子查询，使用mysql5.0吧~~~~