New requirement


Im a newbee for JDE development. pls help in understanding this req and how to approach the solution:

There is a table with 7 records with a unique key
Job Code : J and E.

there are 3 records with J type and 4 records of E type in this table F5509002.
J - is Job type and it has 3 mandotory training courses for that Job and
E - is for Employee the available courses are 4.

requirement is to compare both these J and E types and look for matching training courses
and display the course that is missing in a given date range(table has Job Code, effective start date and End date)

My question is how do I compare these records within the same table and get the desired result.

The report is to be run by Employee or by Company.

Sample data:
SDB JBCD(Job Code) KY(Training Code) EFT EFTE
E 100 ABE 1/1/2014 12/31/2014
E 100 ABSLS 1/1/2013 12/31/2013
E 100 ACMCL1 1/1/2014 12/31/2014
E 100 ABSLS 1/1/2013
J 100 ABE
J 100 AC

Based on this example the report should print
J 100 AC
as this is mandatory for Job but not available for the Employee.
Please help.