|
Hi everyone,
I think this is easy question regarding mysql database.
In a table in my database i have two attributes hours and minutes which
are of type int.I want to create a select statement adding both values and getting a total of both attributes.The following query is what i am using but it doesn't add them all,but separately.
SELECT sum(hours),sum(minutes)FROM TimeSheets where WebuserID='44' group by hours
Please can anyone help me?
Thank you in advance,
Xenia
|
