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