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

    Combined two results sets into one

    Arnej6511

      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?