Hi all, I've got a database which contains a table with several records.. there's a sort of parent/child hierarchy going on.. I want to select a specific parent record and then create a query that'll list all it's child items.. at the moment I can only select the next level down, not all levels of child records.. any ideas?
Table definition is like the following - p_id - autonumber p_parentid - number p_title - text p_active - yes/no A sample selection of records could be - 1 0 Home Yes 2 1 About Us Yes 3 1 Contact Us Yes 4 2 Company Yes 5 2 Staff Yes 6 2 History Yes 7 3 Offices Yes 8 3 Location Yes 9 4 Blah Yes 10 4 Blah 2 Yes So if I was to do a select on 2 - about us, I would expect to get the following results - 4 2 Company Yes 5 2 Staff Yes 6 2 History Yes 9 4 Blah Yes 10 4 Blah 2 Yes Any help with this would be much, much appreciated! Cheers, Alastair ------------------------------------- Xentica - Web & Internet Solutions www.xentica.com Tel: 01423 509433 - Fax: 01423 509502 ------------------------------------- Xentica is a division of Pye Tait Limited. This message is for the named person's use only and is copyright Pye Tait Limited (c) All Rights Reserved. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Any views expressed in this message are those of the individual sender, except where the message states otherwise. Pye Tait Limited is an ISO 9001 Quality Assured Company. ------------------------------------- ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
