Concept
Purpose
A table related to the Primary table is called a Secondary table.
Usage
One table can be related to another table by either a predefined or an ad hoc relationship. A table related to the Primary table is called a Secondary table. A table related to a Secondary table is called a Tertiary table, etc. There can be any number of such relationship levels.
When processing the records in a table, the data in a Secondary table can be accessed if a predefined relationship exists between the tables or if an ad hoc relationship has been established in the current script. A relational operator (all, any, count of, highest of, lowest of, mean of, or sum of) or nested for command is used to access the data in the related table.