4 Replies Latest reply: Dec 19, 2016 10:49 AM by Horst Wangeleile RSS

    How to join 2 tables with all values of one table for all values of the other

    Horst Wangeleile

      Hi, 

       

      I have two tables:

       

      Customer
      A
      B
      C
      Periode
      Jan-2013
      Feb-2013
      Mar-2013

       

      and want to get this result:

       

      CustomerPeriode
      AJan-2013
      AFeb-2013
      AMar-2013
      BJan-2013
      BFeb-2013

       

      Any idea how a script should look like. I was thinking to do it with a JOIN, but I don't find a solution.

       

      Thanks for your help