Hi David,

The query actually worked! My bad, I had a typo when I wrote your query. Thank you.

>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?