Allg. SQL-Problem

[EarlyBird]

Ungetestet könnte es in etwa so gehen:

Code:

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