Period=
2000 (Inspection)
| Inspection | RegNo | DateInspected | Period | Evaluation |
| ABC123 | 2000-01-03 | 2000 | OK | |
| ABC123 | 1999-01-15 | 1999 | OK | |
| DFG456 | 2000-12-04 | 2000 | FAIL | |
| HIK123 | 2000-10-20 | 2000 | OK | |
| TOP111 | 2000-05-11 | 2000 | OK |
| Relation Inspection will be scanned and the value of attribute Period is compared to value 2000. In the first tuple the values are equal and the selection condition is true. This tuple is appended into the result. | ||||||||||
|