Join validation

[#1]

Dear All,

I have 2 table and I don't have any primary key between both the tables...

And its must to join both the table in this way by which I get correct validation result...

Please find the attached files for details..

I want salary should come correct after joining...

Please reply..

Rahul

[tresesco]

This is how join works. To get your desired result, just keep the tables associated (No join).

[anbu1984]

Try this

=Sum(Aggr(Max(DISTINCT Salary),ID))

[Anonymous]

in the expression:

Sum(Aggr(Salary, NAME))

[#5]

If you do not have any business rule on which these 2 table will be joined, then there is no way to get the expected results.

I would request you to redefine the way you want to link these tables.

Thanks,

Singh