>I don't think that's possible (at least not in a single SQL Statement). If you want this result for display purposes you could use a hierarchical flex grid to display it. Although you would probably need an ADO shaped recordset as a data source.
>
< SNIP >

Yes, it's possible with some limitations.