Outer join doesn't work?

[#1]

Hello

I have a problem with an outer join and i can't fix it.

I have two tables with two fields in common, the relation is ok and it's working. i have a few numbers and the sum of them is ok

Now, when i write "Outer Join" i do the same sum and i'm having a larger amount. I don't understand why this is happening. Shouldn't the outer join keep the relation?

Greetings

[vishsaggi]

Look here:

Understanding Join, Keep and Concatenate

Outer Join:

And also outer join gives all values from left table and all values from right table and any non matching values will also be displayed.

[#3]

I understand outer join. You're not answering my question, please read it and if you don't understand me you can say it.

[vishsaggi]

Can you explain little more please ? or a sample to share with the issue ?

[MarcoWedel]

please post an example application and describe your expected result.

thanks

regards

Marco

[johnca]

The relationship with an outer join is indeed maintained between the tables. Why an outer join creates a higher sum is interesting. As suggested by Marco, please post an example of your data and results.

--john