How to look up a value from the 2nd table of 2 available tables

[#1]

Hello,

I need to get a column called P Name from the 2nd table, these two tables have a common fields called ID, how do I do this in qlikview , this is equivalent to vlook up in excel

Any inputs on this would be greatly appreciated

Thanks,

Anusha