Merging Uncommon Tables

[djbateman]

I have 2 tables that have nothing in common, but I want to merge them together.  I think an illustration will work better than trying to explain it:

Table 1

ID
0001
0002
0003
0004
0005
0006

Table 2

Color
Red
Yellow
Green

Desired Table

ID	Color
0001	Red
0001	Yellow
0001	Green
0002	Red
0002	Yellow
0002	Green
0003	Red
0003	Yellow
0003	Green
0004	Red
0004	Yellow
0004	Green
0005	Red
0005	Yellow
0005	Green
0006	Red
0006	Yellow
0006	Green

[Reeza · Accepted solution]

Lookup cross join