Forum: Datenbanken
Delphi
by DeddyH,
20. Feb 2008
Und so?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.
Forum: Datenbanken
Delphi
by DeddyH,
20. Feb 2008
Ohne Gewähr, da aus dem Kopf dahergetippselt: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