Follow along with the video below to see how to install our site as a web app on your home screen.
Anmerkung: This feature currently requires accessing the site using the built-in Safari browser.
SELECT `letzerBesuch` FORM `kunden` WHERE `kundenid` = _DeineId_ ORDER BY `letzerBesuch` DESC LIMIT 0,1
SELECT Kundennummer, MAX(Besuchsdatum) AS MaxBesuchsdatum
FROM Kundenbetreuung
GROUP BY Kundennummer
Select a.Kundennummer, a.MaxBesuchsdatum /*hier jetzt kommagetrennt weitere Spalten*/
FROM (
SELECT Kundennummer, MAX(Besuchsdatum) AS MaxBesuchsdatum
FROM Kundenbetreuung
GROUP BY Kundennummer) as a
Inner Join Kundenbetreuung as b on a.Kundennummer = b.Kundennummer and a.Maxbesuchsdatum = b.Besuchsdatum