Is there a way to do the equivalent of a UNION query ?
I want to do this for a Valid If list in a drop down. Do I need to wrap this in an additional select statement ? It runs but returns the values of the first select only
SELECT(Preferences[Type], [FirstName] = ‘Master’) UNION SELECT(Preferences[Type], [UserEmail] = USEREMAIL())