Joining HRP1001 and PA0002 with SQ02

Hi all,

I'm new to SQ02, I'm used to create report with ABAP.

I'm trying to create a simple query using HRP1001 and PA0002 joined by hrp1001-sobid and pa0002-pernr.

The fields are different so it's not possible to do it with the graphical join interface.

I know I should put some ABAP somewhere in the infoset but I don't know what code and in which code section.

Please provide me with step by step instructions to achieve this.

Thanks