Join-multiplying values

[Mohan23912391]

Hi,

In 1st table I have Composite_Key, ID, Sales, other columns.. In 2nd table I have Composite_Key, New_Value1, New_Value2 columns..

I have used Left join in middle

For 1 ID earlier the Sales used to be 1000.. But after the Join, for the same ID the Sales now became 4000..

Why ? What should I do if I need to get the right table values without effecting left table Sales ?

Thanks

[lukas_]

Hello,
Does the Composite_Key field have duplicates in the 2nd table or 1st table?

Because if there are 4 lines with the same value in the Composite_Key field then it is logical that from one line, you go to 4 and therefore 1000*4 = 4000