Page 225 - Computer - 10(A&B)

Upper Part

Bottom Part

When you type two criteria on the same line, only records where both criteria are met will be displayed
when you run the query. This is called AND condition. When you type one criteria on the Criterion
row and the second criteria on the Or row, the records where either criteria are met will be displayed
as output. This is called OR condition.
For example, in the Student table:

Student detail table
v Query 1: extract records of male students who belong to class X-A (AND condition)
v Query 2: extract records of male students or students in class X-A (OR condition)

AND Condition Query 1

107