DQL Statements › Relationship Clauses › Combining Relationship Types

Combining Relationship Types

You can relate tables by combining simple and complex joins in one of three ways. Choose the RELATED BY clause when combining relationship types. The following describes the methods.

Chained relationship

Establishes a series of relationships through common keys or columns. Can combine simple and complex joins.

Repeating relationship

Establishes relationships by repeating the name of a table as the subject of a clause. Can combine simple and complex joins.

Both chained and repeating

Establishes relationships by combining both of the preceding types of joins.