Versions Compared

Old Version 5

changes.mady.by.user Tabassum Lodhi

Saved on

compared with

New Version 6

changes.mady.by.user Tabassum Lodhi

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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 THAT: The plus sign (plus) is an indicator of an outer join. All keys must be joined in the same manner. If even one key between outer-joined tables is missing it considered as a  standard join. Also, an outer join is permissible between not more than two tables.

...