summing syntax

From: Brock <>
Date: Thu, 24 Sep 2009 20:09:16 -0700 (PDT)
Message-ID: <>

Thanks in advance for any clues! I'm trying to edit an existing stored procedure in Oracle and need to know how to code using SUM in this scenario:

SELECT TableA.FieldA, //character
TableA.FieldB //number

Pseudocode: If FieldA = 'Virginia' then add that record's FieldB to running total
 then running total = TotalReturns
WHERE Received on Thu Sep 24 2009 - 22:09:16 CDT

Original text of this message