Kbase 19598: Query Builder - How to show Customers who have Orders
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/17/2000 |
|
KnowledgeBase Number: 19598
Creation Date: 15-MAR-2000
Modified Date:
This document applies to: Progress Query Builder Join Types
Version and Release Number: Progress Version 7.x and higher
Summary: In a one to many relationship, sometimes it is necessary to display only the records on the 'ONE' side who have related records on the 'MANY' side. This is accomplished by using the default 'INNER-JOIN', however this presents the problem that you will see multiple instances of the same 'ONE' side record.
To get around this, in the 'Query Builder' for the SDO, select the 'Options' Radio-Set at the top of the dialog and under the 'Find' column double-click the word 'EACH' to toggle it to either FIRST or LAST.
In the instance of the Customer and Order tables of the Sports database, in the table section of the query builder, you would select Customer, then Order of Customer, then select the options radio-button and toggle the find type for 'Order of Customer' to FIRST or LAST.
REFERENCES TO WRITTEN DOCUMENTATION
===================================
UIB Developer's Guide (Version 8.x & higher)
Design Window Basics Chapter
Under the Query Builder Options Mode.
AppBuilder Developer's Guide (Version 9.x)
Section 4 (Database-Access Objects)
Under the Query Builder Options Mode.