SELECT ORG1.ID AS COMPID,ORG2.ID AS ORGID
FROM APPUSER.OAMP_ORG_ORGANIZATION ORG1 , OAMP_ORG_ORGANIZATION ORG2
WHERE ORG1.PARENTORGID = 1
AND ORG2.ORGPATH = '%'||RTRIM(LTRIM(CHAR(ORG2.ID)))||'%'
SELECT ORG1.ID AS COMPID,ORG2.ID AS ORGID FROM APPUSER.OAMP_ORG_ORGANIZATION ORG1 , OAMP_ORG_ORGANIZATION ORG2 WHERE ORG1.PARENTORGID = 1 AND ORG2.ORGPATH = '%'||RTRIM(LTRIM(CHAR(ORG2.ID)))||'%' SQL报了下面的错误,请问如何解决呢? [color=#FF0000] 19:32:08.843DBMSCMS
SELECT ORG1.ID AS COMPID,ORG2.ID AS ORGID
FROM APPUSER.OAMP_ORG_ORGANIZATION ORG1 , OAMP_ORG_ORGANIZATION ORG2
WHERE ORG1.PARENTORGID = 1
AND LOCATE (RTRIM(LTRIM(CHAR(ORG2.ID))),ORG2.ORGPATH)>0