The Set Relationship dialog box enables you to create simple, self, composite, unmatched, and non-equal relationships between two tables.
Note: Although you can set relationships using this dialog box, you should use the mouse method to create relationships wherever possible. For relationships created this way, Query Builder automatically activates and deactivates the relationship lines for you.
This dialog box contains:
Relationship |
Specifies the origin (in A->) and target (in B->) column names. |
Operator |
Specifies the type of relationship between the columns. |
Use Relationship in Query |
Specifies if your relationship will be used in the query. Default is checked. |
A not found in B |
Specifies that the data retrieved is all data common to both tables, in addition to data that is in table A, but not in table B. |
B not found in A |
Specifies that the data retrieved is all data common to both tables, in addition to data that is in table B, but not in table A. |
Suppress Mismatches |
Default. Specifies that the data retrieved is common for both tables. |
Creating a simple relationship (Query Builder)
Copyright © 1984, 2005, Oracle. All rights reserved.