Use this feature if you want to display data where one table has no values entered, such as orders with no line items, customers who have not made orders, sales representatives who do not have customers, and so forth. A row that returns a value of 0 (zero) is not the same as an unmatched row. In the Set Relationship dialog box, Suppress Mismatches only works on rows that return null values, not 0 values.
To create an unmatched, or outer, relationship:
Click
in the Icon Bar
to display the Set Relationship dialog box.
About unmatched (null) rows (Query Builder)
Removing unmatched rows (Query Builder)
About Query Builder relationships
Activating and deactivating a relationship (Query Builder)
Creating a composite relationship (Query Builder)
Creating a self-relationship (Query Builder)
Creating a simple relationship (Query Builder)
Deleting a relationship (Query Builder)
Copyright © 1984, 2005, Oracle. All rights reserved.