1 2 3 4 5 6 7
|
select `ientite_salarie`.`matricule` AS `matricule`, `ientite_salarie`.`id_ientite_salarie` AS `id_ientite_salarie`, `ientite_salarie`.`id_salarie` AS `id_salarie`, `isalarie`.`civilite` AS `civilite`, `ientite_salarie`.`nom` AS `nom`, `isalarie`.`prenom` AS `prenom`, `isalarie`.`num_securite_s` AS `num_sec_soc`, `isalarie`.`adresse` AS `adresse`, `isalarie`.`code_postal` AS `code_postal`, `isalarie`.`complement` AS `complement`, `isalarie`.`ville` AS `ville`, sum(`ientite_salarie`. `prelevement`) AS `montant_prelevement`, `interessement`.`id_interessement` AS `id_interessement`, ((sum(`ientite_salarie`.`montant_interessement`) - sum(`ientite_salarie`.`prelevement`)) - sum(`ientite_salarie`.`montant_acompte`)) AS `montant_net`, `ientite_salarie`.`ayant_droit` AS `ayant_droit`, sum(`ientite_salarie`.`montant_interessement`) AS `montant_interessement`, `isalarie`.`designation_entite_actuelle` AS `entite_actuelle`, `isalarie`.`date_depart` AS `date_sortie`
from ((`ientite_salarie` join `isalarie`) join `interessement`)
where ((`interessement`.`id_interessement` = `ientite_salarie`.`id_interessement`)
and (`isalarie`.`id_salarie` = `ientite_salarie`.`id_salarie`)
and (`ientite_salarie`.`ayant_droit` = 1))
group by `ientite_salarie`.`id_salarie` |
Partager