oracle8.1.6 select acs_objects.context_id as package_id, acs_object.name(apm_package.parent_id(acs_objects.context_id)) as parent_name, (select site_node.url(site_nodes.node_id) from site_nodes where site_nodes.object_id = acs_objects.context_id) as url, faqs.faq_id, faqs.faq_name from faqs, acs_objects where faqs.faq_id = acs_objects.object_id and faqs.disabled_p <> 't' and acs_objects.context_id in ([join $list_of_package_ids ", "]) order by lower(faq_name)