使用SQL函数,SQL函数-https://help.fanruan.com/finereport/doc-view-846.html
你的语法拼接错了,拷贝出来,帮你改
用到参数地方,都要+拼接才可以
--------------------
sql("T100_conn","select distinct ooef001 from "+$schema+".ooef_t LEFT JOIN "+$schema+".ooefl_t ON ooefent=ooeflent and ooef001=ooefl001 and ooefl002='zh_CN' where ooefent='"+$ent+"' and ooef201='Y' order by ooef001",1,1)