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