Sql Abfrage

[Ilja]

yo,

SELECT h.id, h.name, SUM(v.preis) Summe
FROM hersteller h
INNER JOIN verkauft v ON v.id_hersteller = h.id
WHERE v.datum BETWEEN '01.06.2008' AND '01.07.2008'
GROUP BY h.id, h.name
ORDER BY 2, 1
;

Ilja