what would be the query for this requirement

Question

i have a dropdown list for the a number of functions like wedding,birthday etc,
and three are two table Employee,AND EmployeeStatus Table

Employee Table
 id     Emp_Id  Name
 1       23      ssss
 2       24      dddd
 3       34       ffff   

and EmployeeStatus Table

id    functionType_Id    Emp_Id    Name    Date
 1        1                 23     sss   10-05-2015
 2        1                 24     ddd    10-05-2015   

i want that when there is more than one function on the same day ,then employee that

are already used up can never used up again,rather employee that are

left behind are allocated for next function for the same day.