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
| ch = "select " _
& "EFFECTUE.date_deb," _
& "EFFECTUE.date_fin," _
& "EFFECTUE.nombre_heure," _
& "EFFECTUE.nombrenombre_heures_supp," _
& "EFFECTUE.num_tache," _
& "EFFECTUE.num_empl," _
& "EFFECTUE.jour_travail," _
& "EMPLOYE.num_empl," _
& "EMPLOYE.nom_empl," _
& "Ordre_de_Travaux.num_ot," _
& "Ordre_de_Travaux.date_ot," _
& "Ordre_de_Travaux.num_tache," _
& "SECTION.section," _
& "SECTION.num_tache," _
& "TACHE.num_tache," _
& "TACHE.nature_tache1," _
& "TACHE.nature_tache2," _
& "TACHE.nature_tache3," _
& "TACHE.nature_tache4 " _
& "From EFFECTUE,EMPLOYE,Ordre_de_Travaux,SECTION,TACHE " _
& "Where SECTION.num_tache=TACHE.num_tache And " _
& "Ordre_de_Travaux.num_tache=TACHE.num_tache And " _
& "EFFECTUE.num_tache=TACHE.num_tache And " _
& "EFFECTUE.num_empl=EMPLOYE.num_empl" |
Partager