Sum()-Daten aus 2 Tabellen in einer Query

[DeddyH]

Und so?

SQL-Code:

SELECT SUM(CASE WHEN (B.BillValue IS NULL) THEN 0 ELSE B.BillValue END) AS BValue,
SUM(CASE WHEN (PT.ProjectTime IS 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

Laut dieser Seite sollte das gehen.