Join two tables, looping through the values in one

[SergeantJack]

Hi, here is my problem, simplified:

Table1:

Alabama

Alaska

Arizona

Arkansas

California

Colorado

Connecticut

Delaware

Florida

Georgia

Table2:

red

white

blue

I want to join the two tables such that the join loops through Table2 and connects its values to Table1 until Table1 is finished, so the end result will look like this:

Joined Table:

Column1       Column2

Alabama       red

Alaska          white

Arizona         blue

Arkansas      red

California      white

Colorado       blue

Connecticut   red

Delaware       white

Florida           blue

Georgia         red

How do I do this?  

[Felipe_Ribeir0 · Accepted solution]

Hi @SergeantJack 

One wayof doing this

[SergeantJack]

That worked perfectly.  Thanks for the quick solution!