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出错了 可是不知道原因在那里 大家帮忙看看
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出错了 可是不知道原因在那里 大家帮忙看看
嗯,mysql4.1以上版本才支持子查询,使用mysql5.0吧~~~~