Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.
select t1.WBS1 , stuff((select ', '+ t2.Label as "data()" from table2 t2 where t1.Org like '%:' + t2.Code and t2.code not in ( 'RE', '00' ) for xml path('')), 1, 2, '') Discipline from table1 t1 group by t1.WBS1, t1.Org
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.