Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all, I have the following tables.
ADM_APPL:
EXT_ORG :
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