SELECT STUFF
((SELECT ';' + Name
FROM BPMDB.dbo.YZAppAttachment
WHERE f.gongying_fujian LIKE '%' + FileID + '%' FOR XML PATH('')), 1, 1, '') AS swfujianming, STUFF
((SELECT ';' + FileID
FROM BPMDB.dbo.YZAppAttachment
WHERE f.gongying_fujian LIKE '%' + FileID + '%' FOR XML PATH('')), 1, 1, '') AS swfujianid, F.TaskID
FROM dbo.ZhaoCai_LuRu AS f, BPMDB.dbo.YZAppAttachment h
WHERE f.gongying_fujian LIKE '%' + h.FileID + '%'
GROUP BY f.gongying_fujian, F.TaskID
相似问题