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

2012-02-11

一个简单的语法错误，就是看不出来，求助……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

热点排行

Bad Request.

SQL Server

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