Need Advice on SQL Query

%3CLINGO-SUB%20id%3D%22lingo-sub-1687644%22%20slang%3D%22en-US%22%3ENeed%20Advice%20on%20SQL%20Query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1687644%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20table(x)%20that%20is%20formed%20by%20joining%202%20tables.%20The%20table%20x%20has%20a%20consists%20of%20a%20column%20perm_parameter.%20This%20Column%20consists%20of%20string%20values%20and%20IDs.%20So%20here%20is%20the%20problem%2C%20the%20IDs%20are%20need%20to%20replaced%20by%20string%20values%20and%20these%20are%20referenced%20in%20another%20table.%20It%20should%20be%20done%20without%20disturbing%20the%20table.%20Please%20suggest.%20Please%20find%20the%20attached%20screenshots.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1687644%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESQL%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1690105%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20Advice%20on%20SQL%20Query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1690105%22%20slang%3D%22en-US%22%3E%3CP%3EPlease%20post%20table%20design%20as%20DDL%2C%20some%20sample%20data%20as%20DML%20statement%20and%20the%20expected%20result.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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. 

1 Reply

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