1 2 3 4 5 6 7 8 9
| "INSERT INTO RECHERCHE ( MATRICULE, NOM, DATESORTIE, POINTEUR, PDCO," & _
" DEGIGNATIONPDCO, PDC, DESIGNATIONPDC, CLASSIFICATION, CARISTE, SST, TUTEUR, FILE, INCENDIE )" & _
" SELECT TABLETAQA.MATRICULE, PERSONNELS.NOM, PPERS.DATESORTIE, PATEL.LIBELLE, PPERS.PDC," & _
" PDWCT2.DESIGNATION, TABLETAQA.PDC, MPDWCT.DESIGNATION, TABLE.CLASSIFICATION, PERSONNELS.CARISTE," & _
" PERSONNELS.SST, PERSONNELS.TUTEUR, PERSONNELS.FILE, PERSONNELS.INCENDIE FROM" & _
" (((((TABLETAQA LEFT JOIN MPDWCT ON TABLETAQA.PDC = MPDWCT.CODE) LEFT JOIN TABLE" & _
" ON TABLETAQA.PDC = TABLE.PDC) LEFT JOIN PERSONNELS ON TABLETAQA.MATRICULE = PERSONNELS.MATRICULE)" & _
" LEFT JOIN PPERS ON TABLETAQA.MATRICULE = PPERS.MATRICULE) LEFT JOIN PATEL ON PPERS.POINTEUR = PATEL.CODE)" & _
" LEFT JOIN PDWCT2 ON PPERS.PDC = PDWCT2.CODE" |
Partager