A composite relationship connects two or more columns in one table with columns in another table. For example, you might relate the columns Order ID and Item ID in the Items table with identically named columns in the Item List table.
You can use as many composite relationships as are appropriate for your query. In addition, you can include columns in composite relationships regardless of whether they are used in other relationships.
To create a composite relationship:
Notice that the cursor traces out a relationship line as you do so.
By default, the relationship is inactive (the line appears gray).
About Query Builder relationships
Activating and deactivating a relationship (Query Builder)
Creating a self-relationship (Query Builder)
Creating a simple relationship (Query Builder)
Creating an unmatched relationship (Query Builder)
Deleting a relationship (Query Builder)
Copyright © 1984, 2005, Oracle. All rights reserved.