Re: Join Logical file using the same physical file twice

[Simon Coulter <shc@xxxxxxxxxxxxxxxxx>]

On 06/03/2008, at 12:27 AM, Mike Cunningham wrote:

> Thanks Simon. I might go try this again and maybe send out the  
> exact source. The only difference I see is that I was joining 1  
> with 2 and 2 with 3. Your example shows joining 1 with 2 and 1 with 3

That was necessary to get the results you wanted. It compiles OK  
using the alternative join just the results are different. Note that  
you were joining file1 to itself (file3). This works but will/may  
give different results.

Regards,
Simon Coulter.
--------------------------------------------------------------------
   FlyByNight Software         OS/400, i5/OS Technical Specialists

   http://www.flybynight.com.au/
   Phone: +61 2 6657 8251   Mobile: +61 0411 091 400        /"\
   Fax:   +61 2 6657 8251                                   \ /
                                                             X
                 ASCII Ribbon campaign against HTML E-Mail  / \
--------------------------------------------------------------------