How to...creat one table out of two.

[david_ze]

Hi All
I have two tables:
tab_1:
my_number
1

2

3

tab_2:

my_latter

A

B

C

I would like to creat new table as follows:

1A

2A

3A

1B

2B

3B

1C

2C

3C

will appreciate your help on the script i should use to do this.

thanks in advanced,

David

[swuehl · Accepted solution]

Hi David,

maybe like this?

tab_1:

LOAD  * INLINE [

my_number

1

2

3

];

tab_2:

LOAD * INLINE [

my_latter

A

B

C

];

tmpResult:

NOCONCATENATE LOAD * resident tab_2;

inner join (tmpResult) LOAD *

resident tab_1;

Result:

LOAD my_number & my_latter as result resident tmpResult;

drop table tmpResult;

Hope this helps,

Stefan

[its_anandrjs]

Hi David,

I suggest you have to load some thing like

tab_1:

LOAD  * INLINE [

my_number

1

2

3

];

tab_2:

LOAD * INLINE [

my_latter

A

B

C

];

Temp:

load

my_latter as Letters

Resident tab_2;

join

Load

my_number as Numbers

Resident tab_1;

Main:

load

Letters&Numbers as NewField

Resident Temp;

Drop tables tab_1,tab_2;

Rgds

Anand

[david_ze]

Thanks Stefan and Anand for the right answer.
David