1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| SELECT TExec.id
, TExec.nom
, CASE WHEN TAxe.id IS NULL THEN NULL ELSE TGrpTypeAxe.idGrpTypeAxe END AS idGrpTypeAxe
FROM TExec
INNER JOIN
TEquipPack
ON TEquipPack.idMos = TExec.id
INNER JOIN
TPackTypeAxe
ON TPackTypeAxe.idPack = TEquipPack.id
INNER JOIN
TTypeAxe
ON TTypeAxe.id = TPackTypeAxe.idTypeAxe
INNER JOIN
TGrpTypeAxe
ON TGrpTypeAxe.id = TTypeAxe.idGrpTypeAxe
LEFT JOIN
TAxe
ON TAxe.id = TGrpTypeAxe.idAxe
WHERE TPackTypeAxe.numAxe = 1
AND COALESCE(TAxe.id, 2) = 2 |
Partager