I have the following table:
POINTS
______
pid
junior
clubpoints
countypoints
junioropenpoints
date
I wish to show a sum for club, county and juniot points grouped by junior. This is fine but now I need to show, in the same table the sum of club county and junior open points before the first of this month and the sum of club county and junior open points after the first of this month.
Any help much appreciated! - I might have to do this in java and manually sort it but I would have prefered an SQL solution.
POINTS
______
pid
junior
clubpoints
countypoints
junioropenpoints
date
I wish to show a sum for club, county and juniot points grouped by junior. This is fine but now I need to show, in the same table the sum of club county and junior open points before the first of this month and the sum of club county and junior open points after the first of this month.
Any help much appreciated! - I might have to do this in java and manually sort it but I would have prefered an SQL solution.