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

The following figure shows, as an example of a data search using a structured repetition predicate, the procedure for searching the staff table for those employees who list a father as a family member.

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