무엇이 잘못되었는지 모르겠네요
해결 좀 부탁드리겠습니다.
사정이 좀 급해서
select 'F' as objType, d.localId as localId, d.dirName as idName, cTime,
d.dirId as ids, d.who, u.userName, d.numSubDir as subDir, d.numDoc,
'' as chkInOut, c.count, 'icon_folder.gif' as icon
from DirectoryTable d, UserTable u,
( select dirId, sum(nvl(accessCount, 0)) as count
from DirectoryAccessCount group by dirId ) c
where d.dirId > 0
and d.parent = 0
and d.dirId =* c.dirId
and d.who = u.userid
|