对于带有子查询和嵌套节点的SQL中的xml

so i have a trigger that is to make XML "transactions" of data changes to client demographic data it is working for the most part but i cannot get the node structure quite right a client can have up to 3 phone records i am trying to get each into its own phone nodes all nested under one client node instead of repeating the entire client node over again with same data running into some trouble using subquerys with phoneso i have a trigger that is to make XML "transa