Question: what is the difference between inner join and referential join in sap hana?
Answer: Hi, A inner join gives data only when it exists in both left and right table. An inner join is always executed. A referential join is also an inner join but it assumes that the referential integrity is maintained.