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.