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?

Shane Gilbert