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..
** 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.