且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

plz修复sql查询错误:语法错误','

更新时间:2023-02-04 07:59:24

您需要在关键字中使用



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