airain
注册会员
UID 94599
精华
0
积分 63
帖子 37
金钱 63 喜悦币
威望 0
人脉 0
阅读权限 20
注册 2007-6-28
状态 离线
|
一个 mysql 的查询问题
高手帮看下这个sql那有错
SELECT a.CT_ID, a.CT_Name, a.CT_ParentID,
IF (
a.CT_ParentID =0, '根课程',
SELECT b.CT_Name
FROM Course_Tree AS b
WHERE b.CT_ID = a.CT_ParentID
) AS CT_ParentName, a.CT_State, a.CT_Level, a.CT_Time
FROM Course_Tree AS a
WHERE a.CT_ID =4 错误提示：
#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 b.CT_Name From Course_Tree as b Where b.CT_ID=a.CT_ParentID) as CT_Parent' at line 1
|
|
