Joining two files with duplicate sales amounts

[#1]

I am doing a left join from file A to file B. For each unique identifier however in file B there are duplicate sales amounts. I only want to join where the sales amounts are unique for each identifier. How would I go about doing this ?

[prashantbaste]

Hello Sid,

As you have done Sum(Amount)  above... similarly you can do Max(Quantity)  aggression and join it with Table A.

Please mark, comments as 'Correct' or 'Helpful'.