I need to generate a XML from the following tables
Section
--------
SectionID
TagName

SectionXREF
----------
SectionID
SectionChildID

SectionElements
---------------
ElementID
TagName

SectionElementsXREF
-----------------
SectionID
ElementID

A Section can have many child sections and each child section can have sub
sections and each section has elements
what i need is for a given section i need all the child sections and their
elements in a single query can you help me.

Thank you in advance