一个简单的语法异常,就是看不出来,

一个简单的语法错误,就是看不出来,求助……SQL codeSELECT*,(SELECT typenameFROM kmtypesWHERE id (SELECT

一个简单的语法错误,就是看不出来,求助……

SQL code
SELECT     *,        (SELECT typename         FROM kmtypes         WHERE id =                   (SELECT upid                  FROM kmtypes                  WHERE id = kmlist.typeid) AS TypeNameFROM         Kmlist


提示AS附近有语法错误

[解决办法]
as 前边再加个 )
[解决办法]
WHERE id = kmlist.typeid)) AS TypeName