Kbase 15655: Opposite of an inner join in TTY Results
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
Opposite of an inner join in TTY Results
To get the opposite of an inner join between the
Customer and order table of the DEMO database:
(opposite of an inner join - only the customer records that
do not have an associated order record)
Select Define -> customer
F4
select cust-num (or whatever)
F1
Select Where
F5 for expert mode
enter NOT CAN-FIND (FIRST demo.order OF demo.customer)
This will give you every customer record that has no associated
order record.
Note!!!
You do not have a join established between customer and order.
You are just filtering the customer table.
Progress Software Technical Support Note # 15655