Query transftorm where clause

[#1]

hi guys

In bods query transform i m trying to write a where clause to filter on a material number. I am able to filter one material number but how can i filter on multiple material numbers. Syntax i m using is

TABLE1.MATERIAL = '10001234'

[former_member187605 · Accepted solution]

Use IN or OR:

1. TABLE1.MATERIAL in (‘A’,’B’)
2. TABLE1.MATERIAL = ‘A’ or TABLE1.MATERIAL = ‘B’

[Former Member]

thanks Dirk.. i know that was very elementary but i am new to it. Appreciate your help.