Re: Join Logical file using the same physical file twice

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 / \
--------------------------------------------------------------------