SELECT nom AS nom_client, solde, numero AS numero_ligne, tarif FROM client, ligne
	WHERE ligne.id_client = client.id
	ORDER BY client.nom ;
