for xml path ......select *,fk=(''+(select [content] as node from C where id=A.id for xml path('name') )) from A
