Adding Fields in Database
Hi, My question is a little away from the eCart, what I want to really accomplish here is I want to be able to add all values in 6 database columns and store it to another column (total) passing a query into the UPDATE form. Is it possible?
Here is a scenario:
UPDATE operating_expenses SET Total = SUM(Fuel + Grease_Oil + Tire_Repais + Parts + Insurance + License_Fees)
Or perhaps this scenario:
SELECT (Fuel + Grease_Oil + Tire_Repais + Parts + Insurance + License_Fees) AS Total FROM operating_expenses
CAN THIS BE DONE?
Thanks,