select * ,FBHT=stuff((select ','+Name from 表B where ManagerContract=A.ID for xml path('')),1,1,'') from 表A as A