Ramil,

>I'm sorry that I did not make my question clear. I need to get all data in TEST1 and TEST3.GetThisVal column. My problem is that TEST3 uses a numeric NWHSE code whereas TEST1 uses a character CWHSE code. I need to join to TEST2 to get the character CWHSE value. Based on the sample below, the desired results would be:
>

>nwhse  cprod  GetThisVal
>1      "A"      1
>1      "C"      3
>2      "B"     22
>3      "A"    111
>3      "D"    222
>

>
>David, I tried the query below but it does not return the desired results above.

That is the exact result I get from the SQL I posted. What result do you get when you run it?