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.