Sql - Sum of field2 - field1

[Diesel]

Employee

------------

 

id int,

firstname varchar(30),

lastname varchar(30),

 

 

Time Table

-----------

employeeid int,

timein datetime,

timeOut datetime

 

Need to Sum total hours given employeeid and date range.

[Robby]

You can do something like this...

 

SELECT E.EmployeeID,

Sum(DateDiff("hh",T.TimeIn,T.TimeOut)) AS Hours

FROM Employee E

INNER JOIN TimeTable T

ON E.EmployeeID = T.EmployeeID

WHERE T.SomeDateColumn Between '1/1/1990' And '1/1/2005'

GROUP BY E.EmployeeID