8 Replies Latest reply: Oct 24, 2018 3:28 AM by Mark Little RSS

    Joining tables

    Wong Dehou

      Hi all, I have the following tables.


      ADM_APPL:

      EMPLIDACAD_CAREERSTDNT_CAR_NBRLAST_SCH_ATTEND
      1000001A0E00001
      1000002B0E00002
      1000003C0E00001


      EXT_ORG :

      EXT_ORG_IDLS_SCHOOL_TYPE
      E00001
      University
      E00002
      College
      E00003
      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.