🚀 go-pugleaf

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.