Re: Liste de contôle
Envoyé par:
aeromorestel
()
Date: lundi 9 janvier 2017 21:03:48
Bonjour,
Je peux te proposer la liste des utilisateurs avec leurs validités.
Select person.name as Code
, last_name as Nom
, first_name as Prenom
, email as Mail
, address as Adresse
, zipcode as CodePostal
, city as Ville
, home_phone as Tel_Domicile
, work_phone as Tel_Travail
, cell_phone as Tel_Mobile
, birthdate as Date_Naissance
, Case sex when 0 then 'M' when 1 then 'F' else '?' End as Sexe
, nationality as Nationalite
, vt1.name as Validite
, v1.expire_date as 'Date Expiration'
, v1.ident_value as Numero
FROM person, validity v1, validity_type vt1
WHERE person.activated = 1
and v1.person_id = person.id
and vt1.id = v1.validity_type_id
ORDER BY Last_name, First_name
--
Cordialement
André TISSOT