Forum Discussion

Harsha2230's avatar
Harsha2230
Copper Contributor
Sep 19, 2020

Need Advice on SQL Query

I have a table(x) that is formed by joining 2 tables. The table x has a consists of a column perm_parameter. This Column consists of string values and IDs. So here is the problem, the IDs are need to replaced by string values and these are referenced in another table. It should be done without disturbing the table. Please suggest. Please find the attached screenshots. 

SQL
  • olafhelper's avatar
    olafhelper
    Bronze Contributor
    Sep 21, 2020

    Please post table design as DDL, some sample data as DML statement and the expected result.

Resources