Mapping of Values

[#1]

Hi All,

I wan to map two column values from 2 different table like below, (Both table are linked using key 1). Column 1 is having Main Problem and Column 2 is having different root cause for the problem.

Table 1	Table 2
Column 1	Column 2
91	91   01
	91   02
	91   03
	91   04
	91   05
	91   06
	91   07
	91   08
	91   09
92	92   01
	92   02
	92   03
	92   04
	92   05
	92   06
	92   07
	92   08
	92   09
	92   10
	92   11
	92   12
	92   13
	92   14

Actually i'm getting value like this,

Table 1
Column 1
0
91
92
93
94
95
96
97
98

Table 2
Column 2
92   **
91   01
91   02
91   03
91   04
91   05
91   06
91   07
91   08
91   09
92   01
92   02
92   03
92   04
92   05
92   06
92   07
92   08
92   09
92   10
92   11
92   12
92   13
92   14

Thanks,

Selva