5 Replies Latest reply: Nov 4, 2015 4:32 AM by jhonatan ben ami RSS

    JOIN QUESTION

    jhonatan ben ami

      HEY I AM HAVING PROBLEMS WITH THE FOLLOWING JOIN

       

      Inv_Sales_Temp:

       

      LOAD

      IVCOST,

      IV,

      CURRENCY ,

       

      FROM [lib://clinton/InvoiceItems.qvd] (qvd);

       

      LEFT JOIN  (Inv_Sales_Temp)

      LOAD

      CUST,

      CUSTNAME,

      COUNTRY,

      CURRENCY

      FROM [lib://clinton/customers.qvd](qvd);

       

      LEFT Join (Inv_Sales_Temp)

      LOAD

      CUST,

      COST

      FROM [lib://clinton/Trans.qvd]

      (qvd);

       

      I ATTACHED THE  ERROR MESSAGE I GOT.