You would be much better off separating the parent data into one
table and the child data into another table and then doing a left
outer join to grab all of the parents and if they have children in
the child table, grab those.
- Jay
On Apr 18, 2006, at 3:11 PM, Norman Palardy wrote:
On Apr 18, 2006, at 11:52 AM, Trausti Thor Johannsson wrote:
Thank you, but what if the sort order is not important, just that
children would come after the parent record ?
Same solution ? Or is that one possible with a single SQLite
command ?
Trausti
Basically this kid of traversal of a hierarchy is NOT possible in
SQL in a general way.
It requires some kind of iterative or recursive query which SQL
cannot do without some kind of language extensions.
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
