SELECT * FROM Parent P INNER JOIN Child C ON C.ParentId = P.ParentId
SELECT P.Name , P.Address , SUM(C.Amount) FROM Parent P INNER JOIN Child C ON C.ParentId = P.ParentId GROUP BY P.Name , P.Address