Join

语法说明

Join 用于来臤个或多个表硌绌绌绌绌绌绌绌绌绌绌绌绌绌绌绌绌合起来。

下图展示了 LEFT JOIN```right Join=inner jagner、和Outer Join`.

• LET JOINS

|Select_list] From Tablea Left Join Tableb B A.KEY=B.Key|key|key|key|key|![leftjoin](https://community-data-13088875761.Can-beijing.com/Acs/LetWork/Doc |–|–| |Selected [Select_list] From Tablea Left Join Tableb B on a.key=b.key where null||

• right Join|

|Select_list] from Tablea Right Join Tableb B On Tables A.key=b.key||p. |–|–| 1 null||

• Ginner Joino`s

|Select_list] From Tablea Inner Join Tableb B A.KEY=B.Key|key|key|key|key|key], (https://community-data-data-13088875761.Can-beijing.com/Acs/Coin)| |–|–|

• UULTL ZAINS

sect_list] from Tablea Full Outer Join Tableb B On Table A.key=b.key
1 null

更多信息，参考

• left join

• right join

• Inner join

• full join

• outer join

• natural join