Merge / Union ALL / combining tables???

Hi,
I've got two tables, in one multiple distinct stores and in another one multiple distinct products.

How do I get list with all the stores multiplied with the products? E.g.

I've been looking for something like merge or union, but these answers only give me some kind of appended list, not a multiplied list.

I can work with PowerPivot, if that makes it easier?

Cheers,
Andy

Got the answer myself with PowerPivot... Thanks to my colleague.

Here the quick solution:
1: create another table with only one value called "link"
2: add all three tables (stores, products, link-table) to the PowerPivot Model
3: in the stores and product table, add a calculated field with the same value you used in the link-table (="link")
3: create a relationship between stores and link and products and link
4: Create a pivot and drag the stores and products into the row value, all values will be multiplied stores x products.

DatiDuke said:

Got the answer myself with PowerPivot... .

Click to expand...

Thank you for publishing solve of the a problem. Probably, this will your solution help others who have the same problem