Chris,
I have a working model of the "nested set tree" in a working Access
database. Let me know if you want a copy of it. It works a little different
then the standard adjacent list (aka, the parent/child relation) but it
seems to work really will. The concept is based off of something in the book
"SQL for Smarties"-which is a great book.
I've implement this model in a SQL Server 7 project I'm working on, and with
everything written as stored procedures it runs incredibly fast-actually,
even the Access 2000 queries run decently.
-Dan
+--------+---------------------------+
| name | Dan G. Switzer, II |
|company | PengoWorks.com |
| www | http://www.pengoworks.com |
| mailto | [EMAIL PROTECTED] |
+--------+---------------------------+
-----Original Message-----
From: Chris Evans [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 18, 2000 9:31 PM
To: [EMAIL PROTECTED]
Subject: Parent/Child query
I have two tables. One contains messages, with MessageID as a primary key
and a bunch of other columns. I have a second table that has a Parent
column, and a MessageID column. I am trying to grab the messages, and use
the Parent and MessageID table to build the parent child relationships. I
want the query to return with parent message followed by children messages.
I can't get it to work correctly, though.
Any ideas?
Chris Evans
[EMAIL PROTECTED]
http://www.fuseware.com
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
