🚀 go-pugleaf

Keith,

I am just learning SQL (plus I am typing this off the top of my head),
so consult a SQL book to be sure I am doing it correctly:

SELECT SUM(I.AMOUNT) FROM INPUT I
    WHERE DIVISION = 1 AND COUNTRY = 1 AND WORK = 1

would be

SELECT SUM(I.AMOUNT) FROM INPUT I, WORK W, COUNTRY C
    WHERE I.DIVISION = W.DD AND I.COUNTRY = C.COUNTRY AND WORK = 1
    GROUP BY DIVISION

Maybe the last part should be "GROUP BY I.DIVISION" - I am not sure.

I hope this points you in the right direction. I know it can be done. If
no one else can help with SQL here, there are a lot of SQL experts that
hang out in the InterBase group. They will not know dBASE but they will
really know SQL.


--
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.