Re: Qryout file problem

[david.kahn@xxxxxxxxxx]

I wrote:

>The third query will similarly produce a file with a record for
>each part at its third lowest location. File selection will be
>PARTFILE, PARTLOC1 and PARTLOC2, matched records,
>PARTFILE part number = PARTLOC1 part number, PARTFILE
>location > PARTLOC1 location,  PARTFILE part number =
>PARTLOC2 part number, PARTFILE location > PARTLOC2
>location. Report summary functions, report break, output type
>and form all as before. We'll call this file PARTLOC3.

In fact the solution is simpler than this. This query only needs to match
PARTFILE with PARTLOC2. Any records in PARTFILE with a part number equal
and location greater than PARTLOC2 will necessarily have the same
relationship to PARTLOC1.

Dave Kahn, ABB Steward Ltd.


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---