Yes. Flink SQL supports this syntax. shadowell <shadow...@126.com> 于2020年5月12日周二 下午3:25写道:
> Hi, > > I am new to Flink SQL, I want to know whether Flink SQL(Flink-1.10) > supports the following join syntax: > > ``` > select a.id, a.col_1, b.col_1, c.col_1 from topic_a a > inner join topic_b b on a.id = b.id > left join topic_c c on a.id = c.id and a.col_1 = c.col_1 and > b.col_1 = c.col_1; > ``` > > Best Regards, > Jie Feng > > Jie Feng > shadow...@126.com > > <https://maas.mail.163.com/dashi-web-extend/html/proSignature.html?ftlId=1&name=shadowell&uid=shadowell%40126.com&iconUrl=https%3A%2F%2Fmail-online.nosdn.127.net%2Fqiyelogo%2FdefaultAvatar.png&items=%5B%22shadowell%40126.com%22%5D> > 签名由 网易邮箱大师 <https://mail.163.com/dashi/dlpro.html?from=mail81> 定制 > -- Benchao Li School of Electronics Engineering and Computer Science, Peking University Tel:+86-15650713730 Email: libenc...@gmail.com; libenc...@pku.edu.cn