DQL Statements › Relationship Clauses › Combining Relationship Types › Chained Relationships

Chained Relationships

Purpose

You can join tables to one another in a series by establishing a series of relationships through common keys or columns. The common key for one relationship can be different from the common key for another relationship in the series. The relationships you establish can be a combination of simple and complex joins.

Example

The following query shows a chained relationship among four tables. The diagram illustrates the relationship.

 FIND ALL VENDOR ROWS
  RELATED BY VENDOR-NO TO ITEMS
  RELATED BY ITEM-NO TO RECEIPTS
  RELATED BY ITEM-NO TO INVENTORY

Chained Relationship Example