Joining two tables

[Anonymous]

Hello, I am stuck with a "field not found" error when i tried joining two tables. I tried to join two different types of sales - one being an oem sales and the other is distributor's sales. I concatenated all the oem sales for 2 periods and called it as revenue table. Then I concatenated the other distributor sale table and stored it as disti_revenue.qvd. I then left join it to the revenue table, the scripts below:

left join (Revenue)

LOAD

     %Calendar_Id                        as POS_Calendar_Id,

     %Transaction_Id                     as POS_Transaction_Id,

     %Material_Id,

     %Product_Line_Id                    as POS_Product_Line_Id,

     %End_Mkt_Id                        as POS_End_Mkt_Id,

     %Distributor_Id                    as POS_Distributor_Id,

     %Branch_Id                            as POS_Branch_Id,

     %PV_Cust_Ship_Id                    as POS_PV_Cust_Ship_Id,

     %PV_Cust_Sold_Id                    as POS_PV_Cust_Sold_Id,

     %PV_Cust_Parent_Id                    as POS_PV_Cust_Parent_Id,

     %PV_Territory_Id                    as POS_PV_Territory_Id,

     %EC_Cust_Ship_Id                    as POS_EC_Cust_Ship_Id,

     %EC_Cust_Sold_Id                    as POS_EC_Cust_Sold_Id,

     %EC_Cust_Parent_Id                    as POS_EC_Cust_Parent_Id,

     %EC_Territory_Id                    as POS_EC_Territory_Id,

     Channel_Type                        as POS_Channel_Type,

     POS_Qty,

     POS_Revenue_Value,

     POS_Resale_Value,

     POS_Disti_Value,

     POS_Direct_Cost,

FROM Disti_Revenue.Qvd;

The error message that i got:

Field not found - <%Calendar_Id>

left join (Revenue)

Please help!! Thanks in advance.

[Anonymous]

Also, I stored the revenue table in a CombinedRevenue.QVD and i opened the QVD itself, there's nothign in the distributor's revenue..