Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
This is duplicated with this one: Joining tables