ramanathan.raman88 (2/2/2013)
Table 1ABCDF
A1B1NULLNULLNULL
A2B2NULLNULLNULL
A3B3NULLNULLNULL
A4B4NULLNULLNULL
A5B5NULLNULLNULL
Table 2
LocName
A1White
A2Black
A3Red
A4Orange
A5Blue
B1Green
B2Yellow
B3Gold
B4Rose
B5Silver
The absolute best way would be to normalize Table 1. 😉
--Jeff Moden
Change is inevitable... Change for the better is not.