Transformation of Oracle outer join to Standard SQL OUTER JOIN statement

oracle_to_outer_join.sql

-- provides all employee that are not higher management
-- includes employees without a job title

SELECT * FROM employees
WHERE jobtitle (+) not in ('manager', 'department head', 'president') 

-- changed to

select * from employees
where jobtitle not in ('manager', 'department head', 'president') 
or jobtitle is null