Differentiate between simple criteria and multiple criteria in a query
Answers
Answered by
6
Answer:
Using multiple criteria
Criteria on the same row are implicitly joined by AND. ...
Criteria on different rows are joined by OR. ...
When you use multiple rows for criteria, the expressions on each row are treated as though they are joined by AND, but each row's worth of criteria are treated as though they are joined by OR.
Answered by
1
Answer:
Using multiple criteria
Criteria on the same row are implicitly joined by AND. ...
Criteria on different rows are joined by OR. ...
When you use multiple rows for criteria, the expressions on each row are treated as though they are joined by AND, but each row's worth of criteria are treated as though they are joined by OR.Explanation:
Similar questions