Referential join and Inner Join

[#1]

Hi HANA experts,

I am not able to understand Referential join and the difference it has with Inner join. When I read through various articles and posts, I think they both are the same. Please throw some light on the above concepts with an example.

Thanks in advance.

Regards,

Vivek

[Former Member]

Hi Vivek,

It has been discussed before in the thread - http://scn.sap.com/thread/3195646

Basically referential join should be used only when the referential integrity between both tables are abolutely guaranteed. It does an inner join (more expensive) if fields form both table are selected. If fields from only the left table is chosen, it does a left outer join (faster) instead.

Referntial joins will not work if you have set a filter on the right join table.

Thanks,

Anooj