Joining two lists

• bpaul 90357

  Valued Member

  Points: 58

  More actions

  May 15, 2017 at 8:31 am

  #402059

  I have a list of Store Locations and an Inventory List. Example below

  Store List
  Store 1
  Store 2
  Store 3

  Inventory List
  Part 1
  Part 2
  Part 3

  What I need would look like below

  Store 1 Part 1
  Store 1 Part 2
  Store 1 Part 3
  Store 2 Part 1
  Store 2 Part 2
  Store 2 Part 3
  Store 3 Part 1
  Store 3 Part 2
  Store 3 Part 3

  Is there a way to code this or do I need to do it manually?

• debasis.yours

  Hall of Fame

  Points: 3529

  More actions

  May 15, 2017 at 8:36 am

  #1942571

  bpaul 90357 - Monday, May 15, 2017 8:31 AM

  I have a list of Store Locations and an Inventory List. Example below

  Store List
  Store 1
  Store 2
  Store 3

  Inventory List
  Part 1
  Part 2
  Part 3

  What I need would look like below

  Store 1 Part 1
  Store 1 Part 2
  Store 1 Part 3
  Store 2 Part 1
  Store 2 Part 2
  Store 2 Part 3
  Store 3 Part 1
  Store 3 Part 2
  Store 3 Part 3

  Is there a way to code this or do I need to do it manually?

  Hi,

  You can achieve this by CROSS JOIN between the two lists.

  Thanks.