I have two table
1. Table1 with fields col1 (primary key) and amount.
2. Table2 with fields col1 (Foreign Key) and Col2.

e.g.

Table1                    Table2
Col1   Amount             Col1      Col2
----   ------             ----      ----
X      100               X        ABC
                          X        MNO
                          X        123

Now if try to generate the report by joining these two tables on col1, I have below structure:

Col1        Amount        Col2
----        ------        ----
X           100            ABC
X           100            MNO
X           100            123

Now the problem arise when try to show the summary of amount. This sum comes as 300.
Can someone help to have summary as 100?

Also appreciate if we can show the data in below format:

Col1        Amount        Col2
----        ------        ----
X           100           ABC/ MNO. 123

Thanks