Ergebnis der Suchanfrage

• Forum: Datenbanken

  Re: Sum()-Daten aus 2 Tabellen in einer Query

    Delphi
    by omata, 21. Feb 2008
  Achso, nebeneinander...
  
  
  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
• Forum: Datenbanken

  Re: Sum()-Daten aus 2 Tabellen in einer Query

    Delphi
    by omata, 21. Feb 2008
  Vielleicht so...
  
  
  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