🚀 go-pugleaf

This would only get the the SUM of the Amount for the country with out
regard for what work area it is.  I would have to limit even further do it
10 times and then do it for each country 10 times.  This is how I currently
do it.  I then stick it into an array and then I can start building the
report.

There has to be a more efficient way of handling this.

Keith

Keith G. Chuvala (TeamB) wrote in message
<355A0F02.8DEC8988@DELETE_THIS.hit.net>...
>> SELECT I.DIVISION, I.COUNTRY, SUM(I.AMOUNT WHERE I.W = "1"), SUM(I.AMOUNT
>> WHERE I.W = "2"), SUM(I.AMOUNT WHERE I.W = "3"),SUM(I.AMOUNT WHERE I.W =
>> "4") FROM INPUT I
>
>
>I think I understand what you're after.  Try this:
>
>  select division,country,sum(amount) from input group by division,country
>
>This will give you an answer table with the sum of Amount for each COUNTY
>within each DIVISION.
>
>kgc