5 Replies Latest reply on May 27, 2010 10:37 AM by Arnej6511

    Combined two results sets into one


      I have two result sets from "Query for Multiple Rows as XML". I would  like to combined the two based on a common id.


      where  a.id = b.id add b.* to a


      I know that a "SetValue" will  allow you to add items to the xml, but how would you do that based on  the ids?