i need to return an ordered result set from a SQL server database table. the relevant structure would look like this (an unshown column determines inclusion): ID Prev_id Next_id 1 1 12 4 12 13 12 1 4 13 4 13 the returned sequence on ID should be: 1 12 4 13 it is just a [doubly] linked list. unfortunately, my SQL references don't provide a clue how to return such a result set. yes, order is supposed to be irrelevant in SQL, but it would simplify downstream processing if the RS came back in order. thanx, robert young ___________________________________________________________________________ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
