select 
	email,
	prenom,
	nom,
	civilite,
	adresse,
	code_postal,
	ville,
	pays as p_pays,
	date_naissance,
	date_inscription
from membre m 
where 
email != ''
and nom != ''
and prenom != ''

union

select
        email,
        prenom,
        nom,
        civilite,
        adresse,
        code_postal,
        ville,
        pays as p_pays,
        date_naissance,
	date_inscription
from membre_historique m
where 
email != ''
and nom != ''
and prenom != ''


group by email