Allg. SQL-Problem

[p80286]

Ich denke EarlyBird liegt da schon ganz richtig:

Code:

SELECT TBL1.STOCK
      ,MYSQL1.INDPE
      ,TBL1.BALANCE
FROM (SELECT STOCK, MAX(BALANCE) AS BALANCE FROM MYSQL1 GROUP BY STOCK) AS TBL1 
          JOIN MYSQL1 ON (TBL1.STOCK = MYSQL1.STOCK AND TBL1.BALANCE = MYSQL1.BALANCE)

(klitzekleine Änderung)

nur wo kommen die 528,.. bei ADDIDAS her???

Gruß
K-H