Flink SQL join usecase

[shadowell]

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@...

签名由 网易邮箱大师 定制

[Benchao Li]

Yes. Flink SQL supports this syntax.

shadowell <[hidden email]> 于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@...

签名由 网易邮箱大师 定制

--