0

I have Table A with columns CompetenceId, Description and Development Action. This is Table A

enter image description here

I have another table B with CompetencyId and Development Action.

enter image description here

As each CompetenceID is having multiple development actions in table B. My requirement is for 'Table A' I need 'Development action' column for a particular competencyId in the same row up on joining Table B. The result should look like below for Table A

enter image description here

How can I achieve this? Thanks in advance

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
SqlLearner
  • 763
  • 8
  • 23
  • 37
  • try using stuff: http://www.sql-server-helper.com/tips/tip-of-the-day.aspx?tkey=3934817c-1a03-4ac9-a0ba-55b2bfbaea0f&tkw=uses-of-the-stuff-string-function – KHeaney Dec 23 '14 at 17:22
  • http://stackoverflow.com/questions/21760969/multiple-rows-to-one-comma-separated-value – dalevross Dec 23 '14 at 17:23

0 Answers0