1 Reply Latest reply: Jul 10, 2012 8:55 AM by j i RSS

    Merge data

      Hi,

       

      I have 3 resident tables:

       

      MARKETS

           Market_ID

           Market_Name

       

      PRODUCTS

           Product_ID

           Product_Name

       

      PERIODS

           Period_ID

           Period

       

      I need to create a temparary table that would have records for each Market_ID, Product_ID, Period_ID. The output should looks like this...

       

      Market_IDProduct_IDPeriod_ID
      A111116
      A111117
      A111118
      A122226
      A122227
      A122228
      A133336
      A133337
      A133338
      A211116
      A211117
      A211118
      A222226
      A222227
      A222228
      A233336
      A233337
      A233338

       

      Is there an easy way to create this table without having to use 'for' loops? it is just too slow. I am wotking with about 500 Markets, 50000 Products and 36 Periods.

       

      Any help would be appreciated.