I guess same issue :

TableA

PID, Amount1

1, 10

1, 20

2, 10

2, 10

3, 30

TableB

PID, Amount2

1, 20

1, 50

2, 30

2, 20

What I want the output is

PID, Amount1, Amount2

1, 30, 70

2, 20, 50

3, 30,

I tried...