')'附近的语法不正确 [英] Incorrect syntax near ')'

问题描述

这是一个SP，当我在SMStudio中执行时出现错误
第15层状态1的7行第102条消息
'')''附近的语法不正确.


声明@tblPossibleAudits表(auditid int)

SELECT DISTINCT TBL.auditid，AD.auditname
从(
选择POS.auditid，将COUNT(AJ.loanmasterid)作为总贷款，将COUNT(IMG.loanmasterid)作为imgloadedloans
FROM @tblPossibleAudits POS内联接审计结AJ
ON AJ.auditid = POS.auditid左联接ldocumentimages IMG)
在IMG.loanmasterid = AJ.loanmasterid
按POS分组.auditid
)
TBL INNER JOIN审核描述AD
ON AD.auditid = TBL.auditid
在哪里TBL.总贷款> TBL.imgloadedloans
ORDER BY AD.auditname
FOR XML AUTO

This is an SP,when i execute in SMStudio it getting error
Msg 102, Level 15, State 1, Line 7
Incorrect syntax near '')''.


DECLARE @tblPossibleAudits TABLE (auditid int)

SELECT DISTINCT TBL.auditid, AD.auditname
FROM (
SELECT POS.auditid, COUNT(AJ.loanmasterid) as totalloans, COUNT(IMG.loanmasterid) as imgloadedloans
FROM @tblPossibleAudits POS INNER JOIN auditjunction AJ
ON AJ.auditid = POS.auditid LEFT JOIN ldocumentimages IMG)
ON IMG.loanmasterid = AJ.loanmasterid
GROUP BY POS.auditid
)
TBL INNER JOIN auditdescriptions AD
ON AD.auditid = TBL.auditid
WHERE TBL.totalloans > TBL.imgloadedloans
ORDER BY AD.auditname
FOR XML AUTO

推荐答案

尝试以下操作:

Try this:

SELECT DISTINCT TBL.auditid
			  , AD.auditname
FROM
	(SELECT POS.auditid
		  , count(AJ.loanmasterid) AS totalloans
		  , count(IMG.loanmasterid) AS imgloadedloans
	 FROM
		 @tblPossibleAudits POS
		 INNER JOIN auditjunction AJ
			 ON AJ.auditid = POS.auditid
		 LEFT JOIN ldocumentimages IMG
			 ON IMG.loanmasterid = AJ.loanmasterid
	 GROUP BY
		 POS.auditid
	)
	TBL
	INNER JOIN auditdescriptions AD
		ON AD.auditid = TBL.auditid
WHERE
	TBL.totalloans > TBL.imgloadedloans
ORDER BY
	AD.auditname
FOR XML
	AUTO

我想在IMG之后还有一个额外的).尝试将其删除.

Hi,

i guess there is an extra ) after IMG.Try removing that.

打开AJ.auditid = POS.auditid左加入ldocumentimages IMG)

从此行删除)...

谢谢

ON AJ.auditid = POS.auditid LEFT JOIN ldocumentimages IMG)

remove ) from this line...

Thanks,

这篇关于')'附近的语法不正确的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！