2 Replies Latest reply: Nov 9, 2012 7:43 AM by mathiass. RSS

    Add specific value to columns resulting in doubling number of rows

      Hi guys ... I need some help for the following problem.

       

      In my loading Script I have two tables:

       

      Table1: some Markets with some Articles

      MarketArticle
      1c
      1a
      1b
      2a

       

      Table2: All Deliverer for each combination of Market and Article

      MarketArticleDeliverer
      1a500
      1b500
      1c100
      2a100

       

      Now I want to join both tables.

      Looks like this:

      MarketArticleDeliverer
      1c100
      1a500
      1b500
      2a100

       

      Until here I have no problems.

      Now I want to add the Value '0' to "Deliverer" for each row of the third table (this will double the number of rows).

       

      Result should look like this table:

       

      Market
      ArticleDeliverer
      1c0
      1c100
      1a0
      1a500
      1b0
      1b500
      2a0
      2a100

       

       

      Anybody got an idea how I can create this last table?

      Thanks for your help!