AnsweredAssumed Answered

group where/and statement

Question asked by deltatango on Jan 17, 2010
Latest reply on Jan 25, 2010 by deltatango

Title

group where/and statement

Post

In Mysql you can use this syntax:

 

field1 = 2 and (field3 = "abc" or field3 = "def" or field3 = "123") 

 

That way you don't have to do something like:

 

field1 = 2 and field3 = "abc" or field1 = 2 and field3 = "def" or field1 = 2 and field3 = "123" 

 

Can you do the same in Filemaker, for example in an if statement in a script? 

Outcomes