i was not going to suggest subqueries, just a three-way join but if it's infinite levels you want, you have to do that yourself
the code can get complex, since you will have to go get all the rows out of the table, store them in an array, and then unravel the hierarchical structure yourself good luck rudy ____ � The WDVL Discussion List from WDVL.COM � ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
