Can I Sum and Subtract In One SQL Statement?
Posted on 2013-12-10
I am using Dreamweaver with ASP.
I have three fields where I have to sum two fields and then subtract the total from the third field. (Customer1 + Customer2) then subtract from Total Inv$
The select statement I think, would be something like this, BUT this one DOES NOT work.
SELECT SUM(Total Inv$)-(Sum(Customer1+Customer2))
Any way of doing this?