Syntax for a select statement

[llheath]

SELECT(salary exempt[EmpEmail], ([department] = “1153111”), TRUE)

how would I add OR department is 115310 in the above statement?
i want to send to all the salary exempt emails that are in those 2 departments

[HBT]

llheath:

SELECT(salary exempt[EmpEmail], ([department] = “1153111”), TRUE)

I guess you want to do this

SELECT(salary exempt[EmpEmail], OR([department] = “1153111”,[department] = “1153110”), TRUE)

[Steve]

Another alternative:

SELECT(salary exempt[EmpEmail], IN([department], {“1153111”, “1153110”}), TRUE)