1 Reply Latest reply: Dec 10, 2015 4:42 AM by Sangram Reddy RSS

    some problem of a "

    jhonatan ben ami

      i have this table :

      Custs:

      //טבלת לקוחות

      LOAD

      CUSTNAME AS CUST_CUSTNAME,

      CUST AS CUST_CUST,

      ADDRESS AS CUST_ADDRESS,

      CURRENCY AS CUST_CURRENCY,

      CUSTDES AS CUST_CUSTDES

      FROM [lib://CLINTON_SAMPLE/customers.qvd]

      (qvd);

       

       

      and i am trying to run this :

      Inv_Sales_temp: //טבלת מכירות כללית

      LOAD

      Date (IVDATE/60/24+32143,'DD/MM/YYYY') AS INV_IVDATE,

      IVNUM AS INV_INVNUM,

      DOC AS INV_DOC,

      IV,

      QPRICE AS INV_QPRICE,

      TOTPRICE AS INV_TOTPRICE,

      "CURRENCY" AS INV_CURRENCY,

      CUST AS INV_CUST,

      DEBIT,

      VAT  AS INV_VAT,

      UDATE AS INV_UDATE,

      PRINTED AS INV_PRINTED,

      FINAL AS INV_FINAL,

      ORD AS INV_ORD ,

      DISCOUNT,

      DISPRICE AS INV_DISCOUNT,

      PAYDATE AS INV_PAYDATE,

      FNCTRANS AS INV_FNCTRANS,

      BOOKNUM AS INV_BOOKNUM,

      AGENT AS INV_AGENT,

      TYPE AS INV_TYPE,

      CHECKING AS INV_CHECKING,

      IMPFILE AS INV_IMPFILE,

      STORNOFLAG AS INV_STORNOFLAG,

      BRANCH AS INV_BRANCH

      FROM [lib://CLINTON_SAMPLE/Invoices.qvd]

      (qvd);

       

       

      //פרטי ת.יומן   

      Left join

      LOAD

      FNCTRANS AS INV_FNCTRANS,

      FNCNUM,FINAL as FNC_FINAL,

      CURDATE AS FNC_CURDATE,

      FNCDATE,

      EXCHANGE3 AS FNC_EXCHANGE3,

      CURRENCY3 AS FNC_CURRENCY3,

      IVNUM AS FNC_IVNUM,

      EXCHANGE2 AS FNC_EXCHANGE2

      FROM [lib://CLINTON_SAMPLE/Fnctrans.qvd]

      (qvd)

      Where FINAL ='Y';

       

       

      left Join (Inv_Sales_temp)

      LOAD

      CUST_CUST AS INV_CUST, CUST_CUSTNAME AS INV_CUSTNAME,CUST_CUSTDES AS INV_CUSTDES

      Resident Custs;

       

      but i am getting this :

      Table not found: left Join (Inv_Sales_temp) LOAD CUST_CUST AS INV_CUST, CUST_CUSTNAME AS INV_CUSTNAME,CUST_CUSTDES AS INV_CUSTDES Resident Custs

       

      i dont realiy understand why.... since i have wrote down custs...