Accumulated Table

[renjithpl]

Hi all,

I have to create an accumulated table

First - i have a table like below

NAME	PLACE
AAA	USA
AAA	CANADA
AAA	JAPAN

Secondly i have seperate table like

CODE

111

222

333

Now i want to use join or a mapping function to get an accumulated table like below

NAME	PLACE	CODE
AAA	USA	111
AAA	CANADA	222
AAA	JAPAN	222
AAA	USA	222
AAA	USA	333
AAA	CANADA	333
AAA	JAPAN	333

Basically, USA has all the three codes, CANADA and JAPAN have two codes (222 and 333) not 111

As i have many countries listed under place and around 10 codes,

Is there any simple method to bring this table

Regards

Ren

[CELAMBARASAN]

Is there any logic behind joining the codes based on the Name and place?