need help for creating sql query for generating xml file with proper arrangement of nodes & elements in the given format
can anybody help me
i am creating a xml file from VS2005 code using adapater

but the nodes & elements in the file needs more grouping as sub elemnts