SELECT HISTO_TAC.ID, HISTO_TAC.DT_CRE AS DATE, HISTO_TAC.HORAIRE AS HORAIRE, COMMUN_APPLICATIONS.NAME AS "NOM APPLICATION", HISTO_TAC.TITRE AS TITRE, COMMUN_GRPINTERV.GRP_NAME AS "NOM EQUIPE", HISTO_TAC.RAS AS OK, HISTO_TAC.PB AS KO, HISTO_TAC.DPL AS DPL, COMMUN_TYPE_NIV1.NAME AS "TYPE", HISTO_INC.IDETAT AS "ETAT"FROM HISTO_TAC,COMMUN_APPLICATIONS,COMMUN_GRPINTERV,COMMUN_TYPE_NIV1,HISTO_INC,COMMUN_TACHESRECWHERE COMMUN_APPLICATIONS.ID=HISTO_TAC.IDAPPLI AND COMMUN_GRPINTERV.ID=HISTO_TAC.GRPINTERV AND COMMUN_TYPE_NIV1.ID=HISTO_TAC.IDTYPE_NIV1 AND HISTO_INC.IDTACHESREC = HISTO_TAC.IDTACHESREC