Finally made some progress
Code:
TTITLE 'RobAir - Pilot Proficiency Test Status'
COLUMN pil_pt135_date -
HEADING 'Last Proficiency Test'
COLUMN req_test_date -
HEADING 'Next Proficiency Test'
SELECT (e.emp_fname ||' '|| e.emp_lname) Pilot, p.pil_pt135_date,
(ADD_MONTHS(p.pil_pt135_date,6)) req_test_date
FROM hartmar.employee e join hartmar.pilot p on e.emp_num = p.emp_num
;
It will show the pilots dates and thier required dates. I think I might be able to handle the rest. Will respond once I make more progress.