Mark Birbeck wrote:

>We use a simple technique where we have a table for attributes and a
>table for elements. The attribute table has a join on the element table
>to say what element the attribute belongs to, whilst the element has
>joins to itself to say who the parent of an element is. This allows us
>to store an object-like tree structure, and so generate XML documents
>from any point in the tree.

Can you help this relational newbie understand the following:

I can see how you could build a tree out of element content very easily. But
what about mixed content?

How do you do a join on XML data that looks like this:

<element>This is #PCDATA<mixed>with mixed content</mixed>and an element

Thanks in advance.

Sam Hunting
Software Performance Systems