What is SAP HANA Join?
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 –
|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.|