I've got a table containing some timesheet data.
Fields are emp, earncode, lo_shift, hi_shift.
SELECT emp, sum(hi_shift - lo_shift) as reghrs from timesheet
where earncode in ('R', 'C', 'X') order by emp
will give me all the regular hours
SELECT emp, sum(hi_shift - lo_shift) as ovrhrs from timesheet
where earncode not in ('R', 'C', 'X') order by emp
will give me all the overtime hours.
How do I combine these to get one result set with emp, reghrs, ovrhrs on
each row.
Frank
________________________________________________________
1stUp.com - Free the Web
Get your free Internet access at http://www.1stUp.com