Relationship and data filtering between different columns.

Hello, I have a doubt about how this problem should be solved. I have two tables, Table A has information about new personnel that enters my company, while table B has the initial requeriment for th...