sqlsdev (6/17/2013)

---

I have 2 lookup tables. I need to get and replace the values from the lookup tables for the below data.

Lookup Table 1

LT_ID Desc

Cat_Code Category

Prod_Code Product

Lookup Table 2

LT_ID Desc

Drama__Q__M Drama

Comedy__Q__M Comedy

Blue__Q_Ray BlueRay

I have another table with the below information

1 Changed Cat_code to Drama__Q__M From Null

2 Changed Product_code to Blue__Q__Ray From Null

3 Changed Cat_code to Comedy__Q__M From Drama__Q__M

from the above I need an output like below

1 Changed Category to Drama From Null

2 Changed Product to BlueRay From Null

3 Changed Category to Comedy From Drama

Can anyone please provide the solution for this?

Thank you in advance