Join mit Limit 1?

[EarlyBird]

eventuell so:

Code:

SELECT T1.*, T3.* FROM Tabelle1 T1
  LEFT OUTER JOIN 
  (SELECT MAX(tb2_ID) AS tb2_ID, tb1_ID FROM tabelle2 GROUP BY tb1_D) T2
     ON T1.tb1_ID = T2.tb2_ID
  INNER JOIN 
  (SELECT tb2_ID, tb1_id, InfoText FROM tabelle2) T3
     ON T2.tb2_ID = T3.tb2_ID
WHERE T1.Bla2 = 'huhu'