How to extract names (Table1) from Id (Table2)

[Anonymous]

I have two tables one for student’s course information, another for Course Instructor Name. The two tables are joined by Course Instructor PIDM which is common key in both tables.

In Expected table (3rd Table I have the Course Instructor PIDM. I want to add the course instructor name on this table too -How can I get this?

Thanks in advance for your time and support. 

[FreemanZ]

hi @Anonymous 

in your expected table, for row of 1100, why 1111 is there, but not 2222 and 3333?

[Anonymous]

Hello Its a created sample data. The rest of the rows would be pulled in similar way. I have updated the screenshot.