Jim Crafton <[EMAIL PROTECTED]> writes: > In my table(s) I need to model a class hierarchy, as well as a > class/var/function belonging to a namespace, and/or a function/var > belonging to a class. In other words a parent/child relationship. If I > simply add a new column to my primary symbols table, call it > "Parent", how would I query for a given row plus any children (and any > of their children, and so on)? If this is too general an SQL question > and it's not appropriate to the list, my apologies.
See http://www.utdt.edu/~mig/sql-trees/ for one concept that could be adopted to use with sqlite. Derrell
