Ayelet123

AND/OR Queries

Discussion created by Ayelet123 on Dec 3, 2017
Latest reply on Dec 4, 2017 by abdallah_91@yahoo.com

It is clear to me when to use AND/OR in queries, but I'm having difficulty in finding a simple way to explain it to the users. 
Somehow, using examples like: "it was John OR Paul" vs. "it wasn't Ringo AND George" didn't work..
 Any ideas?

 

** adding more details to the original post.
I use the following examples:


If you want to select records from more than one category use the following format:
CATEGORY= ‘PARK’ OR CATEGORY = ‘BEACH’

When using the not equal (<>) operator, the format should be:

CATEGORY <> ‘PARK’ AND CATEGORY <> ‘BEACH’

 

For me, the logic is clear but for some of the users it is hard to understand when to use AND and when OR,, and I'm looking for a simple way to explain this.
Thanks 

Outcomes