oracle8.1.6 select site_node.url(min(node_id)) from site_nodes where object_id = (select package_id from forums_forums where forums_forums.forum_id = :forum_id) select site_node.url(min(node_id)) from site_nodes where object_id = (select package_id from forums_forums where forums_forums.forum_id = :forum_id) select subject, content, format from forums_messages start with message_id=:message_id connect by prior message_id = parent_id