日期:2014-05-18  浏览次数:20294 次

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

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



提示AS附近有语法错误

------解决方案--------------------
as 前边再加个 )
------解决方案--------------------
WHERE id = kmlist.typeid)) AS TypeName