SAP HANA Join Tutorial

Join in SAP HANA is used to Join table and information view and select values as per the requirement.

There are following types of Join method to Join SAP HANA tables –

Join Type	Uses	Comment
INNER	Inner Join selects the set of records that match in both the table.
LEFT OUTER JOIN	Left Outer Join selects the complete set of records from the first table, with a matching record from the second table (If Available).	If no match from the second table, Null value select from the second table.
RIGHT OUTER JOIN	Right Outer Join selects the complete set of records from the second table, with matching record from the first table (If Available).	If no match from the first table, Null value select from the first table.
FULL OUTER JOIN	Full Outer Join selects all records from both the table.
REFERENTIAL JOIN	It is same as inner join by assuming that referential entity is maintained between the two tables.	It is available for only attribute view and analytic view.
TEXT JOIN	Text Join are used to select language specific specification	For Getting Description of the column it is used.