I'm trying to put together a custom view for some output elements that would give me various fields from the largest contribution for each customer.
So I've gotten this far in my select statement:
select customer_no, max(cont_amt) as cont_amtfrom vs_contributiongroup by customer_no
But how do I get the ref_no of this largest contribution in there so I can join to the full contribution record and get other info, like gift date, campaign, source, etc.?
Any help would be much appreciated!
Thanks,
Kirk Mortensen
TheatreWorks
Thanks, Kirk, David, and Brian; this really helped with something I’m working on, too!
Lucie at FGO