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.
select a.sku ,b.store ,b.region from (select distinct sku ,region from sku_table1 ) as a inner join store_target_table2 as b on b.region=a.region ;
Wait! Why is this in category replication?
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