SQL改Oracle

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中的 。

SY_YeWuLeiXingWeiHu as B 去掉 as

你这段语句现在 在Oracle中有问题吗？