SELECT t.cust, sum([t.qnty]) AS summe, c.name
FROM tretn AS t INNER JOIN tcust AS c ON t.cust=c.cust
GROUP BY t.cust, c.name
HAVING sum(t.qnty)=
(
SELECT max(summe)
FROM
(SELECT sum([qnty]) as summe
FROM tretn
GROUP BY [cust]
)
);
Ob das in MySql auch so funktioniert, kann ich dir aber nicht wirklich sagen. Only one way to find out...
