sqlserver中多选字符串查询另外一张表拼接对应的数据

select stuff((select ','+objname from contract where charindex(id,pactid) > 0 for xml path('')),1,1,'')  from project where id='2c928b7992f766440192fc2ea39d1042'