Hello Eric, What you want to do is certainly sane, a perfectly reasonable request of a data retrieval language. You can most certainly join a table to itself, using an alias join on id = parentId. If you require arbitrary levels of nesting of topics, then you will need a proper recursive query. Unfortunately recursive queries are an advanced feature of relational DBMS's. IBM DB2 has them. M$ SQL doesn't. Oracle should but I'm not 100%.
Good luck, as they say in Dublin. Simon -- _______________________________________________ Get your free email from http://www.graffiti.net Powered by Outblaze ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body