首页 > SAP > HANA > Different Types of JOINS in SAP HANA
2019
08-27

Different Types of JOINS in SAP HANA

Hello everyone, in this SAP HANA Modeling tutorial, we will learn about Different Types of JOINS in SAP HANA. Lets get started.

A Join is used to connect tables in SAP HANA.Below are the different join types

Inner Join
Left Outer Join
Right Outer Join
Text Join
Referential Join
Temporal Join

1. Inner Join : This join type returns all the records when there is at least one match in both the tables.

2. Left Outer Join : This join type returns all the records from the left table and the matched rows from the right table.

3. Right Outer Join : This join type returns all the records from the right table and the matched rows from left table.

4. Text Join : This join type is used to get the language specific data from the text tables using the  language column-“SPRAS”. It is only available for Attribute Views.

5. Referential Join : This join type is similar to Inner join type, assuming referential integrity is maintained among the tables.Referential Integrity means, the left table always have a corresponding entry on the right table.

最后编辑:
作者:yangsen
本站为个人博客网站,全由我个人维护,我从事SAP开发13年,其它ERP开发7年,基本都是零售行业。本站记录工作学习的过程, 有SAP相关询问专、兼职工作可随时联系我。 有网站相关的问题可直接在文章下方留言,或者联系我。 邮件:yan252@163.com给我。 QQ:415402519