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

Not with one, with two.