Sum()-Daten aus 2 Tabellen in einer Query

[omata]

Achso, nebeneinander...

SQL-Code:

SELECT p.id, p.number, billvalue, projecttime
FROM project p
LEFT JOIN (SELECT projectid AS id, SUM(billvalue) AS billvalue
           FROM bill
           GROUP BY projectid) a
  ON p.id = a.id
LEFT JOIN (SELECT projectid AS id, SUM(projecttime) AS projecttime
           FROM projecttime
           GROUP BY projectid) b
  ON p.id = b.id

Gruss
Thorsten