Retrieving the difference between two field values

[OniLink]

Hi,

What is the SQL code to retrieve the difference between two field values? Field A minus Field B.

Thanks for any help,
~Oni.

[thorpe]

SELECT SUM(fieldA - fieldB) AS total FROM table;