-
-
彭娟 小试身手Lv3
发表于2019-5-7 11:21
悬赏1
已解决
楼主
例如
select XX from tableXX where XX in (1,2,3)
在亿信里面的过滤条件里面写 XX in (1,2,3) 是不行的,只能写成XX=1 and XX=2 and xx=3
select XX from tableXX where XX in (1,2,3)
在亿信里面的过滤条件里面写 XX in (1,2,3) 是不行的,只能写成XX=1 and XX=2 and xx=3
最佳答案
彭娟 发表于 2019-5-7 11:29
bgtsource_code not in (3106,3108,1101)
bgtsource_code not in ["3106","3108","1101"]这样试试
3个回答
彭娟 发表于 2019-5-7 11:29
bgtsource_code not in (3106,3108,1101)
bgtsource_code not in ["3106","3108","1101"]这样试试