JOIN-alternatives in attribute view for what?

[Former Member]

I am trying to understand the JOIN-types for an attribute view and I am using the following tables:

I have set up a simple attribute view like this:

In term of JOINs I have tried the following:

All the above alternatives delivers EXACTLY the same output:

Is this a bug (or a feature) in my system?

I would have expected different JOINs to deliver different results.

What specifically I am looking for in this case is:

I would really appreciate that somebody explains this. Thank you 🙂

[muthuram_shanmugavel2 · Accepted solution]

Hi,

I tried to reproduce the scenario.

For me, I am getting the correct output.

My HANA Version: 1.00.102

Regards,

Muthuram

[Former Member · Accepted solution]

Could you please post a screenshot of the JOIN-definition that produced the correct output in your system. Thank you.

[muthuram_shanmugavel2 · Accepted solution]

Hi,

Please find the Join definition.

Regards,

Muthuram