MS SQL - Abfrage, Hilfe

[Tannenbaum]

SELECT t1.kennziffer, t1.name, t2.von, t2.bis, t2.tage
FROM tabelle1 AS t1, tabelle2 AS t2
WHERE t1.kennziffer = t2.kennziffer
AND t2.von = (SELECT MAX(t3.von) FROM tabelle2 AS t3 WHERE t2.kennziffer = t3.kennziffer)

Alles klar. Ich mach das so, da es doch keine doppelten "max(Von)" vorkommen sollen. Danke ;)