15
I am trying to assist a colleague with a query.
Pgm = SAIL
OR
AND
Status Equal Active
Start Date On Or Before 1/31/2023
AND
End Date On Or Before 1/31/2023
AND
Start Date On Or Before 1/31/2023
End Date On or After 2/1/2023
Which order are the 'AND' Clauses resolved? Top to Bottom?
Hi,
In your query, there are three And groups in a Or group.
The result will satisfy all conditions in any “And Group”.
So the order about 'AND' Clauses resolved doesn’t really matter, And means all conditions in this group should be satisfied.
#1
André Arnaud de Cal...
291,622
Super User 2024 Season 2
#2
Martin Dráb
230,354
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
