Benötige Hilfe bei komplexer SQL Abfrage

[omata]

Moin,

habe mich auch nochmal dran versucht...

SQL-Code:

SELECT person.nachname, 
       Max(Kath1.datum) AS Kath1, 
       Max(Kath22.datum) AS Kath2, 
       Max(Kath3.datum) AS Kath3, 
       Max(Kath4.datum) AS Kath4
FROM (((person 
        LEFT JOIN (pers_kath1 LEFT JOIN Kath1 ON pers_kath1.kath1_id = Kath1.kath1_id) 
          ON person.id = pers_kath1.pers_id) 
        LEFT JOIN (pers_kath3 LEFT JOIN Kath3 ON pers_kath3.kath3_id = Kath3.kath3_id) 
          ON person.id = pers_kath3.pers_id) 
        LEFT JOIN (pers_kath4 LEFT JOIN Kath4 ON pers_kath4.kath4_id = Kath4.kath4_id) 
          ON person.id = pers_kath4.pers_id) 
        LEFT JOIN (pers_kath21 LEFT JOIN (Kath21 LEFT JOIN Kath22 
          ON Kath21.Kath22_id = Kath22.Kath22_id)  
          ON pers_kath21.kath21_id = Kath21.kath21_id) 
          ON person.id = pers_kath21.pers_id 
GROUP BY person.nachname;

MfG
Thorsten