I have two table .
"tblexploatation" with following field:
employee, startwork endwork
patric jon 12/03/2006 07:00:00 12/06/2006 15:00:00
elen kate 01/05/2006 20:00:00 02/05/2006 02:00:00 etc


and "tblholiday"
holiday holidayname
1.1.2006 new year
16.4.2006 eastern
1.5.2006 1 may
25.12.2006 christmas
now I want to see in query hours for each employee who works on holiday.