🚀 go-pugleaf

Geoff,

That would only give me one sum.  I need all of the sums for a particular
country.

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

...which is the more logical way of saying it.  I know the above code is not
correct, but you could do this xbase style using memory variables.

Keith

Geoff Wass wrote in message <35597071.447EAFE2@ibm.net>...
>Keith,
>
>Now that I think about, the Select should be changed, too if you use
>GROUP BY. If I recall any field used in GROUP BY must be listed
>explicitly.
>
>SELECT I.DIVISION, SUM(I.AMOUNT) FROM INPUT I, WORK W, COUNTRY C
>    WHERE I.DIVISION = W.DD AND I.COUNTRY = C.COUNTRY AND I.WORK =
>W.WORK
>    GROUP BY DIVISION
>
>or you could try:
>
>SELECT I.DIVISION, I.COUNTRY, SUM(I.AMOUNT) FROM INPUT I, WORK W,
>COUNTRY C
>    WHERE I.DIVISION = W.DD AND I.COUNTRY = C.COUNTRY AND I.WORK =
>W.WORK
>    GROUP BY DIVISION, COUNTRY
>
>Maybe none of these are correct, but I think you get the drift.
>
>--
>Geoff Wass
>Kuala Lumpur, Malaysia
>
>
>=============================================================
>Please respond to a newsgroup posting by posting a reply (not e-mail).
>In this way, all can help and all can learn!
>
>
>=============================================================
>Triumph is in the first syllable.
>
>