Left Outer Join Abfrage

[omata]

SQL-Code:

SELECT *
FROM master m
LEFT JOIN (SELECT *
           FROM detail d
           WHERE zaehler = (SELECT MAX(zaehler)
                            FROM detail
                            WHERE wert1 = d.wert1)) d
  ON m.wert1 = d.wert1