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 |
| In the third tuple the selection condition is true again and the tuple is appended into the result | ||||||||||||||
|