Database Tuning (MOSC)

MOSC Banner

Replace full outer join

edited Oct 5, 2009 11:03AM in Database Tuning (MOSC) 3 commentsAnswered
Hi,

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center