The document below will guide you in specifying standard Left Outer Join data modeling queries for your standard SQL processor. They will demonstrate first hand the inherent hierarchical processing capabilities within standard SQL that are demonstrated and utilized in this web site to fully integrate with XML. These capabilities include: modeling and processing hierarchical structures, performing joins of hierarchical structures, hierarchical optimization, full support for hierarchical query semantics on complex multi-leg structures, advanced capabilities such as node promotion, fragment processing, structure transformation, and variable structures. You will also be able to see how the relational row set can represent multi-leg hierarchical structures and how the data is preserved hierarchically. There are more than enough hierarchical capabilities needed to support native XML seamless integration.