Flink SQL join usecase

[shadowell <sh...@126.com>]

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
|
|
shadowell@126.com
|
签名由网易邮箱大师定制

Re: Flink SQL join usecase

[Benchao Li <li...@gmail.com>]

Yes. Flink SQL supports this syntax.

shadowell <sh...@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
> shadowell@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: libenchao@gmail.com; libenchao@pku.edu.cn