This must be really simply, but I'm not seeing how to do it right now.
I want to do the following in 1 sql statement so I dont have to do 2 data access.
SELECT SUM(fldAmount) from tbl1 where fldID = @ContactID
SELECT SUM(fldRate * fldHours) from tbl2 WHERE fldID = @ContactID
(there is a subtraction between the 2 sums)