SELECT Person.name, Sum(transaction.price) AS SumOfPrice FROM Person RIGHT JOIN transaction ON Person.id = transaction.pID GROUP BY Person.name ORDER BY Person.name
SELECT Person.name, Sum(transaction.price) AS SumOfPrice FROM Person LEFT JOIN transaction ON Person.id = transaction.pID GROUP BY Person.name ORDER BY Person.name
select Person.Name,sum(transaction.Price) as SumOfPrice from Person left outer join transaction on Person.ID=transaction.Pid group by Person.Name order by Person.Name
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)