How to join 2 tables with all values of one table for all values of the other

[#1]

Hi, 

I have two tables:

Customer
A
B
C

Periode
Jan-2013
Feb-2013
Mar-2013

and want to get this result:

Customer	Periode
A	Jan-2013
A	Feb-2013
A	Mar-2013
B	Jan-2013
B	Feb-2013

Any idea how a script should look like. I was thinking to do it with a JOIN, but I don't find a solution.

Thanks for your help

[sunny_talwar]

Where did C go??? or are you just showing partial output? From your description you seem to be looking for a Cartesian Product?

May be this:

Table:

LOAD Customer

FROM....;

Join (Table)

LOAD Periode

FROM.....;

[#3]

yes you are right, just a partial output.

I tried it, but it doesn't worked.

[sunny_talwar · Accepted solution]

Seems like its working

Script I used:

Table:

LOAD * Inline [

Customer

A

B

C

];

Join (Table)

LOAD * Inline [

Periode

Jan-2013

Feb-2013

Mar-2013

];

[#5]

Yes, thank you.