How to find if categories are set for employees

Hey,

I have a table that records the type of employee say tab1.Now there is another table say tab2 which records the leave classifications that this employee has.I need to check if all classifications are set for the employee on the basis of its type.

Example:
if employee ID 123 has type Exempt
Then employee ID 123 should have rows for overtime,holiday,pto set for him in tab2