How to get Employee absent details ?

Question

Hi,

I have one employee table and Employee attendance table

how to display absent employee details current date  ?

and also display between two date absent send Employee Details

 

Pls post your answeer

thanking you...

venkat