When searching for data by specifying conditions for multiple repetition columns in a table that has repetition columns, use a structured repetition predicate.

Figure 2-29 shows an example of a data search using a structured repetition predicate. In this example, employees who support their father are retrieved from a staff table.

Figure 2-29 Data search example using a structured repetition predicate