hey i am trying to run this simple join but cant proceed , need your help:

[#1]

Inv_Sales_Temp:

LOAD

[IVCOST],

[IV] AS INV_IV,

IVDATE AS INV_IVDATE,

[CURRENCY]  AS INV_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);

[sunny_talwar]

I don't see any common fields where you are doing a left join on? You need to have at least one common field for left join to pick anything from your second table.

[Anonymous]

On what basis you are joining.

You need a common/Unique field between two tables for same.

[Anonymous]

In your tables, you can join Customer and Trans tables on the basis of CUST field which is common and I guess it is CustomerID,

Final_Table:

LOAD

CUST,

CUSTNAME,

COUNTRY,

CURRENCY

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

LEFT Join (Final_Table)

LOAD

CUST,

COST

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

(qvd);

Hope this will help.

[#5]

o.k i corrected my script to:

Inv_Sales_Temp:

LOAD

IVCOST,

IV ,

IVDATE  ,

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);

as you can see the common fields between  InvoiceItems table and  customers table is the currency field and  the mutul fields between customers and trans table is

cust...

[Anonymous]

Ok, I had mentioned common/unique.

No issue, what error you are getting now.

It should join now.