I have two tables, one of them has weeks of year, and the second table has categories. I need to create a table that contains each week and each category, but there's no fields/keys that intersect in two tables:
Table 1:
week1
week2
week3
week4
Table 2:
Cat1
Cat2
Resulting table:
week1 cat1
week1 cat2
week2 cat1
week2 cat2
...
week4 cat1
week4 cat2
I'd like to do this without using many cursors/looping.