Use (+) I do feel the oracle outer join syntax is much simpler than SQL server
在oracle里 select a.cUserNo,a.vcUserName,d.vcDeptName, decode(a.bAdmin,1,'是','否') bAdmin, decode(a.bManagerIf,1,'是','否') bManagerIf, c.vcDesc from smUser a, smUserPrivilege b, smPrivilege c, smDept d where a.cUserNo=b.cUserNo(+) and b.cPrivilegeNo=c.cPrivilegeNo(+) and a.cDeptNo=d.cDeptNo(+) and a.cUserNo='"&strCutUser&"'"
select a.cUserNo,a.vcUserName,d.vcDeptName,
decode(a.bAdmin,1,'是','否') bAdmin,
decode(a.bManagerIf,1,'是','否') bManagerIf,
c.vcDesc
from smUser a,
smUserPrivilege b,
smPrivilege c,
smDept d
where a.cUserNo=b.cUserNo(+)
and b.cPrivilegeNo=c.cPrivilegeNo(+)
and a.cDeptNo=d.cDeptNo(+)
and a.cUserNo='"&strCutUser&"'"