select *,
(select title as 'data()' from t_DiagnosticReason b where b.type=1 and (a.indication & b.id)>0 for xml path('')) as title
from t_a as a
select *,
(select title as 'data()' from t_DiagnosticReason b where b.type=1 and (a.indication & b.id)>0 for xml path('')) as title
from t_a as a
