|

楼主 |
发表于 2010-2-10 15:17:49
|
显示全部楼层
SELECT F_NAME AS F_NAME ,F_FATHERNAME AS F_FATHERNAME FROM (
SELECT TFM.FDISPLAYNAME AS F_NAME,TF.FDISPLAYNAME AS F_FATHERNAME
FROM TORGSYSTEM TM
LEFT JOIN TORGINDEX TR ON UPPER(TM.FGUID)=UPPER(TR.FGUID)
LEFT JOIN TFILESYSTEM TF ON UPPER(TR.FVALUE)=UPPER(TF.FSPACE||TF.FFILENAME)
LEFT JOIN TFILESYSTEM TFM ON UPPER(TFM.FGUID)=UPPER(TF.FPARENTGUID)
WHERE UPPER(TR.FID) = 'ORGUNIT.FUNCREF' AND UPPER(TM.FKIND)='.PTN'AND UPPER(TF.FKIND)='.FUNC' AND TM.FPOSITION='RLZYBJL'
GROUP BY TFM.FDISPLAYNAME,TF.FDISPLAYNAME
UNION
SELECT '' AS F_NAME,TFM.FDISPLAYNAME AS F_FATHERNAME
FROM TORGSYSTEM TM
LEFT JOIN TORGINDEX TR ON UPPER(TM.FGUID)=UPPER(TR.FGUID)
LEFT JOIN TFILESYSTEM TF ON UPPER(TR.FVALUE)=UPPER(TF.FSPACE||TF.FFILENAME)
LEFT JOIN TFILESYSTEM TFM ON UPPER(TFM.FGUID)=UPPER(TF.FPARENTGUID)
WHERE UPPER(TR.FID) = 'ORGUNIT.FUNCREF' AND UPPER(TM.FKIND)='.PTN'AND UPPER(TF.FKIND)='.FUNC' AND TM.FPOSITION='RLZYBJL'
GROUP BY TFM.FDISPLAYNAME)
应该是这个,但是也没有多大区别 |
|