plz修复sql查询错误：语法错误'，' [英] plz fix sql query Error: Incorrect Syntax ','

问题描述

错误：=

消息102，等级15，状态1，行1

'，'附近的语法不正确。

ERROR:=
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near ','.

select distinct b.WFID from WorkFlowStepsSelectionPanels a ,DynamicSelectionPanels b where 
WorkFlowID = 13,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,2,2,2,3,3,3,3,3,3,3,3,3,4,4,4,4,4,4,4,4,4,4,4,
5,5,5,5,6,6,6,6,7,7,7,7,7,7,7,7,7,7,7,7,7,8,8,8,8,8,8,9,9,9,10,10,10,11,11,11,11,11,
12,12,12,12,13,13,13,13,13,13,13,13,14,14,14,14,14,14,14,14,15,15,15,15,15,
16,16,16,16,16,16,18,18,18,18 
and FormatID=3 
and StepNameID = 30,111,118,125,128,130,131,133,134,138,18,19,2,46,47,48,49,89,146,
1,2,20,1,107,112,15,16,2,20,21,71,1,107,108,109,110,2,20,25,29,33,34,1,2,20,32,
1,129,2,25,1,2,51,60,61,65,66,67,69,70,76,88,99,1,140,2,35,44,53,1,2,20,38,39,40,
1,2,41,42,43,1,117,2,64,1,100,157,2,30,58,85,90,1,2,77,78,79,80,81,92,
1,116,120,122,2,1,113,114,119,2,3,56,57,68,63 
and a.SelectionPanelID = b.ID

推荐答案

您需要在关键字中使用

You need to use in keyword

select distinct b.WFID from WorkFlowStepsSelectionPanels a ,DynamicSelectionPanels b where WorkFlowID in ( 13,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,2,2,2,3,3,3,3,3,3,3,3,3,4,4,4,4,4,4,4,4,4,4,4,
5,5,5,5,6,6,6,6,7,7,7,7,7,7,7,7,7,7,7,7,7,8,8,8,8,8,8,9,9,9,10,10,10,11,11,11,11,11,
12,12,12,12,13,13,13,13,13,13,13,13,14,14,14,14,14,14,14,14,15,15,15,15,15,
16,16,16,16,16,16,18,18,18,18) and FormatID = 3 
and StepNameID in( 30,111,118,125,128,130,131,133,134,138,18,19,2,46,47,48,49,89,146,
1,2,20,1,107,112,15,16,2,20,21,71,1,107,108,109,110,2,20,25,29,33,34,1,2,20,32,
1,129,2,25,1,2,51,60,61,65,66,67,69,70,76,88,99,1,140,2,35,44,53,1,2,20,38,39,40,
1,2,41,42,43,1,117,2,64,1,100,157,2,30,58,85,90,1,2,77,78,79,80,81,92,
1,116,120,122,2,1,113,114,119,2,3,56,57,68,63 )
and a.SelectionPanelID = b.ID

这篇关于plz修复sql查询错误：语法错误'，'的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！