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
本文共 145 字，大约阅读时间需要 1 分钟。
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
转载地址：http://xirja.baihongyu.com/