SELECT nom AS "Nom Client", nomstation AS Station 
FROM clients 
JOIN sejours ON clients.id=sejours.id
ORDER BY nom;