Tell

[Former Member]

Hello，Every One

   Who can tell the difference between HANA‘s 5 kinds of table join. (referential join , inner jion , left outer join , right outer join and text join)

Best Regards，

Donald Tang

[former_member184768 · Accepted solution]

Hi Tang,

A simple search on the forum would have saved you some effort as this topic has been discussed multiple times in the past.

Apart from the link mentioned above by Ravi Shankar, you might also want to check the link below.

http://scn.sap.com/people/gemma.durany/blog/2012/08/12/sap-hana-engine-optimization-for-bizy-geeks-e...

Regards,

Ravi

[former_member182779]

Please next time use a better a more descriptive title...

Greetings,

Blag.

[Former Member]

Hi Tang,

Go through the link below for types of joins in SAP HANA @ page number 14, it gives information about types of joins in SAP HANA

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/1052f8d7-4b2a-2f10-6b9d-da8fbdc96...