View Single Post
  #5 (permalink)  
Old December 16th, 2003, 05:11 AM
owain owain is offline
Friend of Wrox
Join Date: Jun 2003
Location: Cardiff, , United Kingdom.
Posts: 231
Thanks: 0
Thanked 0 Times in 0 Posts

Peter, yes I am afraid that I do want the entire tree underneath the specific ID along with all the ancestors.

Jeff, oh dear, and I was hoping someone would come up with a rather clever correlated sub-query that I couldn't think of, not a suggestion to read an entire book :). Arr well, back to the drawing board, I guess I will have to do it programmatically in my front end.

Jonas, thanks for the link. I have not had a chance to read it all yet but it looks like the sort of thing I am after.

Owain Williams
Reply With Quote