In SAP HANA, there are several types of joins available to combine data from multiple tables. The common types of joins supported in SAP HANA are as follows:
Inner Join: An inner join returns only the matching records from both tables. It combines rows from two tables based on a specified join condition.
Left Outer Join: A left outer join returns all the records from the left (or first) table and the matching records from the right (or second) table. If there is no match, NULL values are returned for the right table.
Right Outer Join: A right outer join returns all the records from the right (or second) table and the matching records from the left (or first) table. If there is no match, NULL values are returned for the left table.
Full Outer Join: A full outer join returns all the records from both tables, including the unmatched records from both sides. If there is no match, NULL values are returned for the respective table.
Cross Join: A cross join, also known as a Cartesian join, combines each row from the first table with each row from the second table. It results in a Cartesian product, producing a large result set.
Self-Join: A self-join is a join in which a table is joined with itself. It is useful when you want to combine rows within the same table based on a specific condition.
These join types can be used in SAP HANA SQL queries to combine data from multiple tables based on the desired relationships and requirements.
