SELECT a.FileID, a.FileName, a.ParentId, to_char(a.CreateDate,'yyyy-MM-dd') as CreateDate , NVL(c.ProjectID, 0) AS ProjectID,UDS_Disk_FolderMark.Mark, d.NodeID
FROM (SELECT FileID, FileName, ParentId, to_char(CreateDate,'yyyy-MM-dd') as CreateDate , Flag, FolderType
FROM UDS_Disk_File
WHERE (Flag = 0)) a LEFT OUTER JOIN
UDS_Disk_FolderMark ON a.FileID = UDS_Disk_FolderMark.FileId
LEFT OUTER JOIN
UDS_Disk_DiskInProject c ON a.FileID = c.FileID INNER JOIN
(SELECT NodeID, NodeValueId
FROM UDS_NodeTree
WHERE (NodeType = 4)) d ON a.FileID = d.NodeValueId
FROM (SELECT FileID, FileName, ParentId, to_char(CreateDate,'yyyy-MM-dd') as CreateDate , Flag, FolderType
FROM UDS_Disk_File
WHERE (Flag = 0)) a LEFT OUTER JOIN
UDS_Disk_FolderMark ON a.FileID = UDS_Disk_FolderMark.FileId
LEFT OUTER JOIN
UDS_Disk_DiskInProject c ON a.FileID = c.FileID INNER JOIN
(SELECT NodeID, NodeValueId
FROM UDS_NodeTree
WHERE (NodeType = 4)) d ON a.FileID = d.NodeValueId
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货