Mitglieder

SELECT DISTINCT People.*, People_Email.Email FROM People_Group INNER JOIN ((People LEFT JOIN People_Email ON People.ID = People_Email.Person) INNER JOIN People_Group AS Funktion ON People.ID = Funktion.Person) ON People_Group.Person = People.ID WHERE People.Active = 1 AND (People_Email.Public = 1 OR IsNULL(People_Email.Public)) AND People_Group.Gruppe = 2 AND (People_Group.Status = 4 OR People_Group.Status = 6 OR People_Group.Status = 9 OR People_Group.Status = 11 OR People_Group.Status = 13) AND (People.Ende > #12/13/2018# OR IsNULL(People.Ende)) AND People.ID = 620 ORDER BY People.Arbeitgeber, People.Name, People.Vorname