1.单引号里面直接写SQL语句,把查出来的结果放到环境树里面 SET beforeBusinessCursor.ext.NODE_PATH[] = PASSTHRU('select A.* from SD_DATA_NODE_PATH AS A left join SD_EVENT_INFO AS B on A.EVENT_ID=B.ID where B.TYPE_CODE='''||eventName||'');