SELECT DISTINCT People.* FROM People LEFT JOIN Ort_Koordinaten ON People.PLZ = Ort_Koordinaten.PLZ WHERE People.Active = 1 AND People.Status4 = 1 AND (People.Ende > #12/21/2024# OR IsNULL(People.Ende)) AND People.ID = 2652 ORDER BY People.Arbeitgeber, People.Name, People.Vorname
Praktikumsstellen
Adresse
Chablais Contrôle Sàrl, Steve Schmuck
Rue Clos-Novex 48B
1868 Collombey