select b.class_gubun, a.class_code, b.class_name, a.sub_class_name, a.cp_code, a.cp_service_url, a.manager_user_id, a.manager_name, a.manager_telephone, a.manager_email, a.list_yn, a.event_file_name, a.event_yn, a.banner_yn, a.banner_file_name, a.banner_url, a.banner_target, a.banner_count, a.recommend_yn, a.popular_yn, a.use_yn, a.memo, a.update_man, a.update_date, a.sub_class_file_name, a.sub_class_date, a.sub_class_place, a.sub_class_money, a.sub_class_purpose from sub_class_info a, class_info b where a.sub_class_code = 848 and a.class_code = b.class_code