Hi all, I have the following tables.
ADM_APPL:
| EMPLID | ACAD_CAREER | STDNT_CAR_NBR | LAST_SCH_ATTEND |
|---|
| 1000001 | A | 0 | E00001 |
| 1000002 | B | 0 | E00002 |
| 1000003 | C | 0 | E00001 |
EXT_ORG :
| EXT_ORG_ID | LS_SCHOOL_TYPE |
|---|
| University |
| College |
| High School |
For all EMPLID, I want to get the LS_SCHOOL_TYPE where the values in LAST_SCH_ATTEND=EXT_ORG_ID.
EG. EMPLID 1000001 should show University.
EMPLID 1000002 should show College.
EMPLID 1000003 should show University.
How do I do this?
Much help is appreciated. Thank you so much.
