1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
| SELECT LAST([deplacement].N_dep), deplacement.frais
FROM sal_dep , salaries , deplacement , nomage, classe
where
(IIF ( [nomage].nomage like "%" ,
(
(
([deplacement].dure_dep -[deplacement].Nbj_sans_prise)*[nomage].inden_j_nom
)+([deplacement].dure_dep - [deplacement].Nbj_avec_prise)*[nomage].inden_j_nom/2
),
(IIF ( [nomage].nomage like "" , ((([deplacement].dure_dep -[deplacement].Nbj_sans_prise)*[classe].inden_j_hier)+([deplacement].dure_dep-
[deplacement].Nbj_avec_prise)*[classe].inden_j_hier/2)))
and [deplacement].N_dep = [salar_dep].N_dep and [salar_dep].matricule = [salaries].matricule and [salaries].classe = [classe].classe and [salaries].nomage = [nomage].nomage)); |
Partager