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;