I've tried it out and yes, I'm able to join the selected value to the column with your sql code using concat. It's what I was looking for.

cheers