ksql支持from后边跟多张概念表名吗？

qunqun0811

例如：  SELECT *
  FROM SA_OPORG T, FLOW_OPROLE_OPORG T1, FLOW_PROCESS T2, SA_OPAUTHORIZE T3
WHERE T.SPARENT = T1.DEPTID
   AND T1.MAINID = T2.FID
   AND T2. SPROCESS =
       '/Unicom_OA/customerWork/process/customerWork/customerWorkProcess'
   AND T2.SACTIVITY = 'businessActivity3'
   AND T3.SAUTHORIZEROLEID = T1.ROLEID
   AND T.SID = T3.SORGID

jishuang

可以用关联查询实现