How to calculate a value for all rows in sql server?
This query solved my problem.

SELECT DISTINCT 
  UPL.memberid, 
  UPL.membershipdate, 
  PaymentSum.sumamount 
FROM user_project_linkingtable AS UPL 
LEFT JOIN (SELECT 
            memberid, 
            Sum(amount) AS SumAmount 
            FROM payment 
            GROUP BY memberid) AS PaymentSum 
 ON UPL.memberid = PaymentSum.memberid;