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
| SELECT i.idintervention AS numero,
contrat.typeContrat AS contrat,
s.situationIntervention AS lieu,
t.typeIntervention AS typeIntervention,
u.username AS intervenant,
c.nomClient AS client,
i.dateIntervention,
i.tacheAFaireIntervention AS tacheAFaire,
i.tacheFaiteIntervention AS tacheFaite,
i.remarqueIntervention AS remarque,
i.heureintervention AS heure,
i.heureComptabiliseIntervention AS heureComptabilisee,
u2.username AS validerPar
FROM intervention i INNER JOIN contrat
ON i.contrat_idcontrat=contrat.idcontrat
INNER JOIN situationintervention s
ON i.situationintervention_idsituationintervention= s.idSituationIntervention
INNER JOIN typeintervention t
ON t.idTypeIntervention= i.typeIntervention_idtypeIntervention
INNER JOIN users u
ON u.idUser= i.user_iduser
INNER JOIN client c
ON c.idclient= i.client_idclient
INNER JOIN users u2
ON i.validerParIntervention = u2.idUser
WHERE i.idintervention="100" |
