select B.NAME AS businessName,A.* from (SELECT n.userId,n.userName,t.businessType,count(t.businessType) as countNum
FROM T_OA_Task t,T_OA_TaskNode n where t.id = n.taskId
and n.userId in (select id from HI_User WHERE org = 1)
and n.status = 1 group by n.userId,n.userName,t.businessType) A left join SY_YeWuLeiXingWeiHu as B on A.businessType = B.id
这句在Oracle中怎么改才能运行呢 。
以前是写在SQL中的 。