Replace full outer join
We would like to know the closest alternative to 'FULL OUTER JOIN'. The requirement is that output should contain all the rows.
Following is my SQL
SELECT TRIM (ee_company_id),
fspemp.do_not_termn_by_absence,
fspemp.employee_termination_date,
exclude_fax_ind,
trim(fspemp.first_name),
trim(fspemp.last_name),
trim(fspemp.eligibility_comp_id)
FROM fmla_employee_eligibility_data eed
FULL OUTER JOIN
(SELECT org.uses_elig_comp_id_ind,
opl.org_id,
opl.person_id,
opl.old_employee_number,
opl.eligibility_comp_id,
fp.ssn,
opl.do_not_termn_by_absence,
opl.employee_termination_date