HANA JOINS

[Former Member]

Hello all,

I have a basic question, May I know which is the best join to be preferred if there is no referential integrity between the tables and also what is the main difference between Referential and inner join?

[Former Member · Accepted solution]

Hi Vinni Jadav,

The best join to be preferred if there is no referential integrity between the tables is Inner Join.

To know the difference between Referential and inner join go through below thread.

[Former Member · Accepted solution]

Thanks srihari... your answer was helpful. I have one more question.

Assume I have 2columns A,B .. I have created calculation view on top of that.Can I query in the view to get the number of columns A>B = Win and number of columns A<B = lose.

Thanks in Advance,

Shravya.B

[Former Member · Accepted solution]

Hi

Can you please elaborate your query with example..

Do you what apply the logic inside Calculation view? or Want to query on top of the Calculation view?

[Former Member · Accepted solution]

HI Srihari,

I have to add few columns in the view, where columns are created by doing some calculations from tabA&B, I would like to query inside the view.

Calculations are like, if an entry1 of tabA> Entr1 of Tab B then create a new column as Win,

if an entry1 of tabA < Entr1 of Tab B then create a new column as lose6

If you can suggest some other option, it would be great help.

[Former Member · Accepted solution]

Hi

Create a Calculated column with below logic

If column A > column B then Win else B (need find correct syntax of Expression editor)