Repeat values for each row

[Dezzie]

I have two tables:

Number

1

2

3

4

and 

Letter

A

B

I'm trying to create the following output:

Number	Letter
1	A
1	B
2	A
2	B
3	A
3	B
4	A
4	B

How can I do this considering there's nothing to join on? Both of these initial tables are coming from SQL queries and are not a sequence.

[MarqueeCrew · Accepted solution]

@Dezzie,

This is a job for APPEND FIELDS.  Take table #1 in as the Left and #2 as the Right and see what happens!

Cheers,

Mark