Re: A query question -Reply

[Scott Cornell <CORNELLS@xxxxxxxxxxxxxxx>]

Neither single query technique I've seen gives the right answer.  Take
the follwing simple example:

Master                    Detail1                          Detail(again)
Cust 100                 Cust 100, 10.00CR      Cust 100, 10.00CR
                               Cust 100, 10.00DB      Cust 100, 10.00DB
                               Cust 100, 15.00CR      Cust 100, 15.00CR

Correct answer would be Cust 100   25.00CR  10.00DB

Rick's query results in the following
Cust 100          10.00CR         10.00CR
Cust 100          10.00CR         10.00DB
Cust 100          10.00CR         15.00CR
Cust 100          10.00DB         10.00CR
Cust 100          10.00DB         10.00DB
Cust 100          10.00DB         15.00CR
Cust 100          15.00CR         10.00CR
Cust 100          15.00CR         10.00DB
Cust 100          15.00CR         15.00CR

Totals               45.00CR          45.00CR

Whereas Bob L's query isn't even possible - you can't do join selects to
constants, so you can't "join only credits" or "join only debits" (which
were IDed, as I recall, by a value in a particular field in the Detail not the
Master file).

Sadly (at least from a simplicity/elegance standpoint) multiple queries as
suggested by David K. is the only way I've ever been able to resolve
just this problem using Query.
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the Midrange System Mailing List!  To submit a new message,   *
* send your mail to "MIDRANGE-L@midrange.com".  To unsubscribe from     *
* this list send email to MAJORDOMO@midrange.com and specify            *
* 'unsubscribe MIDRANGE-L' in the body of your message.  Questions      *
* should be directed to the list owner / operator: david@midrange.com   *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *