试一试select * from OrderA orderA join OrderB orderB on orderA.user=orderB.user
On Sun, Oct 4, 2020 at 5:09 PM 忝忝向仧 <153488...@qq.com> wrote: > Hi,all: > > > Table api的sql查询里面join的时候不能写"."么? > 这样写就会报错 如下 > Exception in thread "main" org.apache.flink.table.api.SqlParserException: > SQL parse failed. Encountered "." at line 1, column 36. > Was expecting one of: > <EOF> > "EXCEPT" ... > "FETCH" ... > "FROM" ... > "INTERSECT" ... > "LIMIT" ... > "OFFSET" ... > "ORDER" ... > "MINUS" ... > "UNION" ... > "," ... > > > > Table result = tEnv.sqlQuery("select * from OrderA join OrderB on > OrderA.user=OrderB.user");