Yeah, it's a CROSS JOIN in SQL. But it's not instinctive.
Table 1 = 0, 1, 2, 3
Table 2 = A, B, C, D
CountTable =
0, A, 100
0, A, 200
0, B, 1
0, D, 47
SELECT *
INTO #TempCJ
FROM Table1 CROSS JOIN Table2
End up with
0, A
1, A
2, A
3, A
0, B etc etc etc
in #TempCJ
Then...