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 26 27 28 29 30 31 32
| SELECT GIT_TGIT_Int.NO_DEMANDE, GIT_TGIT_Int.NO_INTER, GIT_TNOM_Typint.ZL_LIB, GIT_TNOM_Typint_1.ZL_LIB, GIT_TNOM_Standard.ZL_LIB, GIT_TNOM_Standard_1.ZL_LIB
FROM
GIT_TNOM_Typint AS GIT_TNOM_Typint_1
INNER JOIN
(GIT_TNOM_Standard AS GIT_TNOM_Standard_1
INNER JOIN
(GIT_TNOM_Typint
INNER JOIN
(GIT_TNOM_Standard
INNER JOIN
(GIT_TGIT_Int
INNER JOIN
GITIM_TGIT_Int
ON
(GIT_TGIT_Int.NO_DEMANDE = GITIM_TGIT_Int.NO_DEMANDE)
AND
(GIT_TGIT_Int.NO_INTER = GITIM_TGIT_Int.NO_INTER))
ON
(GIT_TNOM_Standard.CD_STANDARD = GIT_TGIT_Int.CD_STANDARD_REAL)
AND
(GIT_TNOM_Standard.CD_TYP_INT = GIT_TGIT_Int.CD_TYPINT_REAL)) ON
GIT_TNOM_Typint.CD_TYPINT = GIT_TGIT_Int.CD_TYPINT_REAL)
ON
(GIT_TNOM_Standard_1.CD_STANDARD = GITIM_TGIT_Int.CD_STANDARD_REAL)
AND
(GIT_TNOM_Standard_1.CD_TYP_INT = GITIM_TGIT_Int.CD_TYPINT_REAL))
ON
GIT_TNOM_Typint_1.CD_TYPINT = GITIM_TGIT_Int.CD_TYPINT_REAL
WHERE ((([GIT_TNOM_Typint]![CD_TYPINT])<>[GIT_TNOM_Typint_1]![CD_TYPINT])) OR ((([GIT_TNOM_Standard]![CD_STANDARD])<>[GIT_TNOM_Standard_1]![CD_STANDARD]))
WITH OWNERACCESS OPTION; |
Partager