Skip to Content
Former Member
Oct 02, 2009 at 10:26 AM

internal table



I have 2 internal tables which i am supposed to merge as 1. the problem here is that the the relation is 1: N

table A table B

key 1 desc Key 1 Value1

Key 1 Value 2

key 1 Value 3

And my final output should be

key 1 desc value1 value2 value3. One thing I know is there wont be more than 9 values in table b for every one in table a. Any quick ideas?