I have a request to look throught the tables and find any employee that does not have a particular license code in there file.
The table contains a record for each employee and a license tpye. example
EMPID
Liccode
Start Date
End Date
Notify (0/1)
Required (0/1)
There are mulitiply records for each employee one for each lic code.
How do I create a report that will show me thoses employees that are missing a certain license code.
IP Logged
