stuff((select ','+bz (要查询的字段名) from t_qjgl_qjdjxq b where a.id=b.qjdjid for xml path('')),1,1,'') AS bz效果