select t.id ,(select vname from (select distinct c.vname, rownum rn
from dbo_bond.tb_usertask_dealed b, tb_user_info c
where b.l_user_id = c.l_id
and b.l_step_id = 5
and b.id = t.id)
where rn=3)
from dbo_bond.tb_project_main t order by t.id
为什么 b.id = t.id 这个条件无效?
from dbo_bond.tb_usertask_dealed b, tb_user_info c
where b.l_user_id = c.l_id
and b.l_step_id = 5
and b.id = t.id)
where rn=3)
from dbo_bond.tb_project_main t order by t.id
为什么 b.id = t.id 这个条件无效?
都没有什么关联条件怎么这样写呢?
from dbo_bond.tb_usertask_dealed b, tb_user_info c
where b.l_user_id = c.l_id
and b.l_step_id = 5
and b.id = t.id)
where rn=3)
这个返回了多个值