Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Table1:
- Col1 | Col2 | Col3
- a1 | b1 | c1
- a2 | b1 | c2
- a3 | b2 | c3
- Table2:
- Col1 | Col2 | Col3
- a1 | y1 | z1
- a2 | y3 | z2
- a3 | y3 | z3
- SELECT Col1,
- (CASE Col2
- WHEN 'ENXTPAR_ID' THEN 'XPAR'
- WHEN 'ENXTAMS_ID' THEN 'XAMS'
- WHEN 'ENXTLIS_ID' THEN 'ENXL'
- ELSE Col2
- END) as Col2,
- Col3
- FROM Table1
- INNER JOIN Table2
- ON Table1.Col1= convert(varchar,Table2.Col1)
- AND Table1.Col2 = Table2.Col2
Add Comment
Please, Sign In to add comment