1 2 3
| 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