Re: SQL ? - summing same field, two results

[dmmueller@xxxxxxx]

Luis, 
I am studying a giving pattern of our donors, from their first donation, 
how does it compare to their overall total giving. 
In this example, you will see that he entered the file in 1992, but no 
money entered until 1999.  So I'm interested in the 1999 date, along with 
the first money of $20.

Now, I know I could write an RPG program and accomplish this, 
BUT..... I remember a COMMON with Skip M, he stated there isn't anything 
you can do in RPG, that you can't in SQL --- so I try to follow that when 
I can  :) 

(thanks for your interest in my post!) 


TMDONR
 TMAMNT 
TMUPDTI

Query statement should return: 

1234
 $                     -   
1/20/1992
TMDONR
First Money
First $ Date
Total Money
1234
 $                     -   
6/14/1992
1234
 $            20.00 
2/21/1999
 $     1,006.75 
1234
 $                     -   
8/3/1992

1234
 $                     -   
7/11/1994
1234
 $                     -   
2/7/1999
1234
 $              20.00 
2/21/1999
1234
 $                     -   
3/14/1999
1234
 $                     -   
3/16/1999
1234
 $              10.00 
4/3/1999
1234
 $                 5.00 
6/28/1999


Diane Mueller
 


From:   "Luis Rodriguez" <luisro58@xxxxxxxxx>
To:     "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Date:   11/08/2018 08:40 AM
Subject:        Re: SQL ? - summing same field, two results



Diane,

Right now I'm out of the office but, could you send me a sample of your
data (4 or 5 lines will do) and the name of the relevant columns (fields)?

Luis
Regards,

Sent from my Moto G phone. Please excuse my brevity.

On Thu, Nov 8, 2018, 10:15 <dmmueller@xxxxxxx wrote:

> Luis,
> I can get the examples to run, although no results.
> Still, you've given me something to work with, I'll keep testing/playing
> with this.... one statement at a time till I get the results.
>
> Again, appreciate your examples given!
> Thanks,
> Diane Mueller
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com