Left join statment

[#1]

Hi,

Im having problem with joining tables together, im trying to add the values from C_OUTBOUND_DELIVERY_BOX.QTY_TO_DELIVER

  ,C_OUTBOUND_DELIVERY_BOX.CONTRACT based on Key_BOX. I have to problems after the left join statment.

1. Theres added to new columns, but one has no columnname and the second has the name: C_OUTBOUND_DELIVERY_BOX-1

2. the values of the new columns are only "-"

Tmp:

load

          Key_BOX

          ,RETWHO_BOX_IN_STOCK_OVERVIEW_Copy.QTY_IN_STOCK

          ,RETWHO_BOX_IN_STOCK_OVERVIEW_Copy.CONTRACT

          ,1 as RetwhoQtyInStockDC

resident RETWHO_BOX_IN_STOCK_OVERVIEW_Copy;

left join (Tmp)

load

          Key_BOX

          ,C_OUTBOUND_DELIVERY_BOX.QTY_TO_DELIVER

          ,C_OUTBOUND_DELIVERY_BOX.CONTRACT

resident C_OUTBOUND_DELIVERY_BOX;

thanks

[jagannalla]

Hello,

Your code is correct. Can you plz attach sample file with data.

[er_mohit]

try concatenate function replace of join

hope it helps

[Gabriel]

Hi,

Please post sample data file.

[#5 · Accepted solution]

thanks for your answers, but i fixed it with: unQualify *;