Syntax for a select statement

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

I guess you want to do this

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

1 Like

Another alternative:

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