Information générale
Catégorie:
Codage, syntaxe et commandes
>I need to sum 2 fields within a table. THis table contains the following needed fields:
>
>claims.dbf
>CONO,INNO,LCH_TOT,SUPR_TOT
>
>The first 2 cono and inno combine(cono+'-'+inno) to make the agreement number. I need to SUM lch_tot, supr_tot, and lch_tot + spr_tot for each agreement number and then total the whole bunch. ANy suggestions? Also where can I found some good material to educate myself on SELECT-SQL?
SELECT cono + "-" + inno AS AgrNo, SUM(lch_tot) AS SumLch, SUM(supr_tot) AS SumSupr;
FROM Claims;
GROUP BY cono, inno
SUM SumLch + SumSupr TO lnGrandTotal
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement