Tabelle richtig gruppieren.... nur wie?

[sx2008]

Zitat von omata:

SQL-Code:

SELECT SUM(SNH_GELD) AS GeldTotal, 
       SUM(SNH_AUSGEZAHLT) AS ProvisionTotal, 
       (SELECT SUM(SNV_MENGE) 
        FROM SNACKVERKAUF) AS DosenTotal
FROM SNACK_HAUPT H

Da fehlt noch 'ne Where-Bedingung in der Unterabfrage

SQL-Code:

SELECT SUM(SNH_GELD) AS GeldTotal, 
       SUM(SNH_AUSGEZAHLT) AS ProvisionTotal, 
       (SELECT SUM(SNV_MENGE) 
        FROM SNACKVERKAUF WHERE SNACKVERKAUF.SNV_ID=SNACK_HAUPT.SNH_ID) AS DosenTotal
FROM SNACK_HAUPT