1 Reply Latest reply: Jul 1, 2013 2:09 PM by sree anaarasi RSS

    Proper Inner Join syntax not working

    Robert Fishel

      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;