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

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