oracle8.1.6 select dotlrn_classes.class_key, dotlrn_community_types.pretty_name, dotlrn_community_types.package_id from dotlrn_classes, dotlrn_community_types where dotlrn_community_types.community_type = dotlrn_classes.class_key order by dotlrn_classes.class_key