Sum()-Daten aus 2 Tabellen in einer Query

[omata]

Vielleicht so...

SQL-Code:

SELECT id, number, SUM(value) value
FROM (SELECT SUM(billvalue) AS value, 1 AS flag, p.id, p.number
      FROM bill x
      INNER JOIN project p
        ON p.id = x.projectid
      GROUP BY p.id, p.number

      UNION ALL

      SELECT SUM(projecttime) AS value, 2 AS flag, p.id, p.number
      FROM projecttime x
      INNER JOIN project p 
        ON p.id = x.projectid
      GROUP BY p.id, p.number) x
GROUP BY id, number

Gruss
Thorsten