Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
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.......