Code: Alles auswählen
SELECT "M_ID", "Name", "Vorname", "Geb-Datum", DATEDIFF( 'yy', "Geb-Datum", CURRENT_DATE ) - CASEWHEN( DAYOFYEAR( "Geb-Datum" ) > DAYOFYEAR( CURRENT_DATE ), 1, 0 ) AS "Alter", "Anrede", "Straße", "PLZ", "Ort", "Land", "Telefon1", "Telefon2", "Telefax", "Telefax", "E-Mail", "Eintritt", "Austritt", DATEDIFF( 'yy', "Eintritt", CURDATE( ) ) AS "Mitgliedsjahre", "Bemerkung", "Foto", "Status" FROM "tbl_Mitglieder"
Danke schon mal im Voraus aus Berlin