Accumulated Table

renjithpl — Tue, 04 Dec 2012 21:35:36 GMT

Hi all,

I have to create an accumulated table

First - i have a table like below

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

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

Re: Accumulated Table

CELAMBARASAN — Tue, 04 Dec 2012 22:23:15 GMT

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