Proper Inner Join syntax not working

Anonymous — Mon, 01 Jul 2013 17:48:38 GMT

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;

Re: Proper Inner Join syntax not working

shree909 — Mon, 01 Jul 2013 18:09:56 GMT

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.......

topic Re: Proper Inner Join syntax not working in QlikView

Proper Inner Join syntax not working

Re: Proper Inner Join syntax not working