Lets complete a catalogue...repeated N iterations

Hello group,
I need help, maybe it's easy for you.. I need to repeat N iterations from N Store numbers in the second table also these stores are cluster for group of regions, so any sku could have different stores depending of the region. Also considered that If I calculated manually it's about 3 millions values. I hope help me to find a way to solve.

Try this:

select a.sku
  from (select distinct
          from sku_table1
       ) as a
       inner join store_target_table2 as b
               on b.region=a.region

Wait! Why is this in category replication?

1 Like

Wow!! what a simple solution just aggregate a distinct in the first select and works perfectly.Thanks
I new in the blog sorry for the category