I'm trying to add static values into my IN operator.
我正在尝试将静态值添加到我的IN运算符中。
Such as
如
Where Customers.Name in ('Jack', 'Jill')
But I'm only able to add one value for an = operator
但我只能为=运算符添加一个值
Such as
如
Where Customers.Name = 'Jack'
I am able to type them into the Formula window
我可以在公式窗口中输入它们
But, Is there a way to graphically choose values for the IN operator, rather than have to type them?
但是，有没有办法以图形方式为IN运算符选择值，而不是必须键入它们？
1 个解决方案
#1
0
Yes. Click the ellipsis button on the Where line of the field you want to query on. Then pick In (instead of equals) and check the boxes in the drop down for the items you want.
是。单击要查询的字段的“位置”行上的省略号按钮。然后选择In（而不是equals）并选中下拉框中的所需项目。
(src: http://www.toadworld.com/products/toad-data-point/f/36/t/29888)
（src：http：//www.toadworld.com/products/toad-data-point/f/36/t/29888）
#1
0
Yes. Click the ellipsis button on the Where line of the field you want to query on. Then pick In (instead of equals) and check the boxes in the drop down for the items you want.
是。单击要查询的字段的“位置”行上的省略号按钮。然后选择In（而不是equals）并选中下拉框中的所需项目。
(src: http://www.toadworld.com/products/toad-data-point/f/36/t/29888)
（src：http：//www.toadworld.com/products/toad-data-point/f/36/t/29888）