Try that.
Code:
SELECT (e.emp_fname ||' '|| e.emp_lname) Pilot, p.pil_pt135_date, e.emp_hire_date
FROM hartmar.employee e JOIN hartmar.pilot p ON e.emp_num = p.emp_num
WHERE p.pil_license = '&my_pilot_license_type'
ORDER BY Pilot;
If it still craps out, try switching the order of the tables
Code:
FROM hartmar.pilot p JOIN hartmar.employee e ON p.emp_num = e.emp_num