Join 2 Tables

[MH376]

I have following table 2 tables named Self_Review and R_tab:

Self_Review:
LOAD * INLINE [
OfficeName, Employee_Name
"Adams Office", John Scott
"Adams Office", Stephen Avey
"Andersen Office", Brad Smith
"Andersen Office", Nader Yeager
"Bob Office", Jonathan Arzani
"Bob Office", Lucy Parker
"Bob Office", Jade Smith
"Bob Office", Daniel Wade
"Grant Office", Grant Saka
"Grant Office", Mike Arnold
"Grant Office", Chris Paul
];

R_TAB:
LOAD * INLINE [
OFC, R_NAME, R_UID, INITIALS, DEPT
"Adams Office", John Scott, 1001, JSC, HR
"Adams Office", Stephen Avey, 2007, SAV, FIN
"Adams Office", John Scott, 2200, JSC, HR
"Adams Office", Stephen Avey, 1009, SAV, FIN
"Bob Office", Jonathan Arzani, 2001, JAR, HR
"Bob Office", Lucy Parker, 4001, LPA, SALES
"Bob Office", Jonathan Arzani, 2003, JAR, HR
"Andersen Office", Brad Smith, 2010, BSM, SALES
"Andersen Office", Nader Yeager, 4009, NYE, FIN
"Harrison Office", Eric Reece, 5001, ERE, HR
"Harrison Office", Kim White, 5003, KWH, FIN
];
I need to create a final table with which needs to named still as R_TAB  as shown in attached screenshot.

[PrashantSangle]

just do outer join. like

R_TAB:
LOAD * INLINE [
OFC, R_NAME, R_UID, INITIALS, DEPT
"Adams Office", John Scott, 1001, JSC, HR
"Adams Office", Stephen Avey, 2007, SAV, FIN
"Adams Office", John Scott, 2200, JSC, HR
"Adams Office", Stephen Avey, 1009, SAV, FIN
"Bob Office", Jonathan Arzani, 2001, JAR, HR
"Bob Office", Lucy Parker, 4001, LPA, SALES
"Bob Office", Jonathan Arzani, 2003, JAR, HR
"Andersen Office", Brad Smith, 2010, BSM, SALES
"Andersen Office", Nader Yeager, 4009, NYE, FIN
"Harrison Office", Eric Reece, 5001, ERE, HR
"Harrison Office", Kim White, 5003, KWH, FIN
];

join

LOAD OfficeName as OFC, Employee_Name as R_NAME INLINE [
OfficeName, Employee_Name
"Adams Office", John Scott
"Adams Office", Stephen Avey
"Andersen Office", Brad Smith
"Andersen Office", Nader Yeager
"Bob Office", Jonathan Arzani
"Bob Office", Lucy Parker
"Bob Office", Jade Smith
"Bob Office", Daniel Wade
"Grant Office", Grant Saka
"Grant Office", Mike Arnold
"Grant Office", Chris Paul
];