If I understand what you're asking for correctly, this should do it:

SELECT C.Name, SUM(P.Total), SUM(O.Total)

FROM Customer AS C

LEFT OUTER JOIN [Order] AS O

ON O.CustomerID = C.CustomerID

LEFT OUTER JOIN Payment AS P

ON P.CustomerID = C.CustomerID

GROUP BY C.Name