Logical File/Outer Join

[setuthill]

Greetings, is it possible to create a logical join file using the F4801
(primary) and the F4802 as an outer join? i.e. if there are no F4802
records one would still get the F4801 record? F4801 = Work Order Master,
F4802 = Work Order Notes... thanks, s.e.t.

Seth E. Tuthill
Anderson Bakery Co. Inc.
[email protected]
A7.3 C 8 V4R2M0

 

[dkahn]

Seth,

Try using the JDFTVAL keyword at the file level. This will cause primary file records for which there is no match in the secondary file to be included in the join using default values for the secondary file fields. Without the JDFTVAL keyword specified, unmatched primary file records are ignored.

Dave Kahn (World A7.3 cum 10)
=========

 

[aschoenberger]

You should be able to do that with Query, but not World Writer. I believe
you are a World client, correct?

 

[Emad_S_Banoub74]

You need to use JDFTVAL (Join Default) key word.

Emad Banoub
MWH
Pasadena, CA
626-568-6529
A7.3 cu 12/X3 - Xe SP 13.0




stuthill <[email protected]>@jdelist.com on 07/16/2001 04:36:24
AM