Load 2 resident tables with an inner join witn NoConcatenate option

[meysspi]

I will link LOAD NoConcatenate 2 tables with an inner join on field PROJECT_PKID

TABLE_A_TEMP:

NoConcatenate
LOAD * Resident TABLE_A
WHERE LCM_HED_TP_CD='CNT';

DROP TABLE TABLE_A;

RENAME Table TABLE_A_TEMP to TABLE_A;

INNER JOIN (PROJECT_PKID)  // table A and Table B have a common field PROJECT_PKID

TABLE_B_TEMP:

NoConcatenate
LOAD * Resident TABLE_B;

DROP TABLE  TABLE_B;

RENAME Table TABLE_B_TEMP TO TABLE_B;

but the NoConcatenate doesn't work with the TABLE_B  , 

If a delete NoConcatenate the script works but the Table B is concatenated to the Table A

[Digvijay_Singh]

TABLE_A_TEMP:

After inner join, we don't specify field name, its the first table we want to inner join with the upcoming table.

May be try like this - 

NoConcatenate
LOAD * Resident TABLE_A
WHERE LCM_HED_TP_CD='CNT';

DROP TABLE TABLE_A;

RENAME Table TABLE_A_TEMP to TABLE_A;

INNER JOIN (TABLE_A)  // table A and Table B have a common field PROJECT_PKID

LOAD * Resident TABLE_B;

The final output should be in Table_A.