在SQLSERVER2000里没有问题,在ORACLE上出上面的错误.
在SQLSERVER2000的环境里,扩展成:
SELECT TDEPT.FDISPLAYNAME as DEPTNAME, TPERSON.FDISPLAYNAME as NAME, TPERSON.FID as ID
FROM TDEPT, TPERSON
WHERE FDEPTID IN
(SELECT OS2.FID FROM TORGSYSTEM AS OS1, TORGSYSTEM AS OS2
WHERE OS1.FID = &[Biz:\SYSTEM\ORGPARAMS.PARAMGROUP\ORGANID.Param] AND
(OS2.FKIND IN ('.OGN', '.DPT')) AND
(OS2.FGUID = OS1.FGUID OR (OS2.FSPACE + OS2.FID + OS2.FKIND LIKE OS1.FSPACE + OS1.FID + OS1.FKIND + '\%'))) AND
TDEPT.FID = TPERSON.FDEPTID
ORDER BY TDEPT.FDISPLAYNAME, TPERSON.FDISPLAYNAME
下拉时是有稍微的停顿感。 |