1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34
|
SELECT
info.matricule AS matricule,
info.nom AS nom,
info.cin AS cin,
info.date_naiss AS date_naiss,
info.sexe AS sexe,
info.cnss AS cnss,
info.telephone1 AS telephone1,
info.telephone2 AS telephone2,
info.site_travail AS site_travail,
info.situation_civile AS situation_civile,
info.qualification AS qualification,
info.experience AS experience,
info.etat AS etat,
info.rib AS rib,
info.situation AS situation,
info.age AS age,
info.date_emb AS date_emb,
info.anci AS anci,
info.num AS num,
info.nbre_enf AS nbre_enf,
info.adresse AS adresse,
info.nbre_contracts AS nbre_contracts,
info.ancian_mois AS ancian_mois,
info.ancian_jrs AS ancian_jrs,
info.depot_cnss AS depot_cnss,
info.cin_le AS cin_le,
info.etranger AS etranger
FROM
info
WHERE
info.site_travail = {Paramsite}
AND info.qualification = {Paramqualif} |
Partager