Hi Team,
Need help on below requirement
Table1:
Guide region code
1 EAME N22
2 APAC N33
3 CHINA N22
4 NA N33
5 APAC N11
Table2:
Guide Number category
1 31 BS
2 32 SK
3 33 PB
4 34 BS
5 35 SK
Based on category i need each number and each region need separately, Guide column is common in both tables .
Out put:
BS_Number BS_EAME BS_NA
31 N22 -
34 - N33
Similarly like other category as well
Regards,
Sravan.
