Re: SQL ? - summing same field, two results

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