dwain.c (7/22/2013)

---

rackerland (7/22/2013)

---

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 =...

Thanks for the answers

but the result is wrong

my datebase sqlite

rackerland (7/22/2013)

---

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

...