integrating tables

[Anonymous]

Hi,

I need to join 2 tables in the script in the following way:

Table1 includes Field1 with the values 1,2,3.

Table2 includes Field2 with the values a,b,c.

I need to create Table3 which integrates Field1 and Field2 in the following way:

Field1 Field2

1 a

1 b

1 c

2 a

2 b

2 c

3 a

3 b

3 c

How can I do it?

Thank you in advance,

Larisa

[swuehl · Accepted solution]

A simple JOIN should do.

LOAD Field1

FROM FIELD1TABLE;

JOIN

LOAD Field2

FROM FIELD2TABLE;

[Colin-Albert]

Table1:

load

Field1

from ..... ;

join (Table1)

load

Field2

from .... ;

[sathishkumar_go]

Hi,

Table3:

load field1 from Table1;

join (Table3)

load field2 from Table2;

-Sathish

[Anonymous]

Thank you!