...
Code Block |
---|
Select (fields) from ACAD_PROG PROG , ACAD_PLAN PLAN , ACAD_SUBPLAN SPLAN Where PROG.EMPLID = PLAN.EMPLID And PROG.ACAD_CAREER = PLAN.ACAD_CAREER And PROG.STDNT_CAR_NBR = PLAN.STDNT_CAR_NBR And PROG.EFFDT = PLAN.EFFDT AndPROG.EFFSEQ = PLAN.EFFSEQ And PLAN.EMPLID = SPLAN.EMPLID (+) And PLAN.ACAD_CAREER = SPLAN.ACAD_CAREER (+) And PLAN.STDNT_CAR_NBR = SPLAN.STDNT_CAR_NBR (+) And PLAN.EFFDT = SPLAN.EFFDT (+) And PLAN.EFFSEQ = SPLAN.EFFSEQ (+) And PLAN.ACAD_PLAN = SPLAN.ACAD_PLAN (+) |
Note |
---|
NOTE: The plus sign |
...
missing it considered as a standard join. Also, an outer join is permissible between not more than two tables. |
To Review: Use a standard join between two tables which contain data; use an outer join between two tables, one of which may or may not contain data.