将select插入select

我需要获取所选用户的用户名 party_id ,但我需要插入而不是 派对id ,我尝试嵌套子查询,但总是被括号卡住。

我选择了这个而不是 gm.party_id 在第二个选项中选择:

SELECT * FROM (
  select gm.party_id, sum(gm.game_out)
  from game_record gm
  where gm.party_id in (
    select cs.party_id
    from casino_users cs
    where cs.parent_id=get_party_id_from_promo(619)
  ) 
  group by party_id
  order by sum(game_out) desc
)
WHERE ROWNUM <= 10;

我需要插入此选项:

select username
from casino_users
where party_id in (
  select cs.party_id
  from casino_users cs
  where cs.parent_id=get_party_id_from_promo(619)
)

username函数也可以从中返回 派对id 但当我试图编译它时,我在第一次选择中得到了一个无效的标识符错误。

FUNCTION get_top_ten_highscore(p_promo_code number) RETURN WEAK_CUR IS
 resault_set weak_cur;

begin

 open resault_set for

     SELECT * FROM (
       select username_from_id (gm.party_id) as party_id, sum(gm.game_out)
       from game_record gm
       where gm.party_id in (
         select cs.party_id
         from casino_users cs
         where cs.parent_id=get_party_id_from_promo(619)
       ) 
       group by party_id
       order by game_out desc)
    WHERE ROWNUM <= 10;
    return  resault_set ;

end get_top_ten_highscore;