Proper Inner Join syntax not working

[Anonymous]

Hello all.  I am trying to perform a simple inner join between two tables.  I am not sure if this syntax is right but cannot figure out why it would not be.  I truly appreciate any help on this issue.  Thanks.

       tblCore_A:
       LOAD '1' AS RowMaster, PSPLN As Task_Number, RESERVELOCATION, PSCASN, PSSYR + PSSTYL + PSSSFX AS SKU, PSSZDS, 
       PSSQTY, PSQPUL, PSRLOC AS ActiveLocation 
       RESIDENT tblPull;
 
       INNER JOIN(tblCore_A)
 
       Load Task_Number
       RESIDENT tblTasks
       WHERE available = FALSE;
 
 
 
 
 
 
 
 
 
 
 

[shree909]

Hi

To work inner join u need to have same column or filednames same

but in tblCore_A i dont fine the field name  Task_Number,

thats the reason its throwing an error.......