I have two tables: "tblexploatation" with field name:
ordinal, employee, works from(format is both date and time) , works to(format is both date and time).
and "tblholiday" with field name:
holiday(format is short date), holiday name.
Now I want to make a query where I can see the hours for each employee who works on holiday.



holiday is : new year, 1 may, eastern, christmas and other.