>>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.

In one SQL statement? How's that done?