STUFF((SELECT ','+t.ResourceName FROM OrderRelation t WHERE t.orderid=p.tableid FOR XML PATH('')), 1, 1, '') pname