Join mit Limit 1?

[Mavarik]

Habs:

SELECT A.*, B.* FROM TBL1 A, TBL2 B where (bla1="huhu") AND B.ID = (SELECT C.ID FROM TBL2 C WHERE A.ID=C.TBL_1_ID Order BY B.ID DESC LIMIT 1) order by ID;