Sum()-Daten aus 2 Tabellen in einer Query

[DeddyH]

Ohne Gewähr, da aus dem Kopf dahergetippselt:

SQL-Code:

SELECT SUM(CASE B.BillValue WHEN NULL THEN 0 ELSE B.BillValue END) AS BValue, 
SUM(CASE PT.ProjectTime WHEN NULL THEN 0 ELSE PT.ProjectTime END) AS PTime, 
P.id, P.Number
FROM Project P
LEFT JOIN ProjectTime PT ON PT.ProjectId = P.Id
LEFT JOIN Bill B ON B.ProjectId = P.Id
GROUP BY P.Id, P.Number