ANDs ORs & NOTs

[Chris Long]

Greetings,

 

Can anyone explain how ANDs and ORs are handled in ENGLISH?

 

When I try to mix ANDs and ORs together, I sometimes get odd results.  I’m not aware of any symbol that would allow one to group clauses.  Is there are way to order them or group them to help get consistent results?

 

For instance, suppose I wanted to create a statement that would behave like below:

 

SELECT filename (WITH a = “1” AND WITH b = “2” AND WITH c = “3”) OR (WITH c = “3” AND WITH d = “4”) OR WITH e = “5”

 

Chris Long