4 Replies Latest reply: Jan 4, 2013 9:46 AM by marten.nilsson RSS

    Left join statment

      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