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
|
SELECT tmp.*
FROM
(SELECT DISTINCT axe.id idAxe, axe.des desAxe, comp.des competencedes, dtable_2.lien competenceid
FROM dtable dtable_1, dtable dtable_2, des_v1 desv1, des_d desd,dtableaxe, dtable comp ,dtable emploi
WHERE dtable_1.id = desv1.id_pere
AND desd.id_desc IN (1106778)
AND desd.id_volet IN (830018, 830022, 830020)
AND desv1.id = desd.id_volet
AND desd.id_table = dtable_2.id
AND dtable_1.tc = 'DESC.NOMGPE2'
AND desv1.type = 'COMP'
AND axe.nom_table = 'REFCOMP0'
AND axe.id =comp.lien
AND comp.nom_table = 'REFCOMP1'
AND dtable_2.lien=comp.id
AND desd.id_desc=emploi.id
UNION
SELECT DISTINCT axe.id idAxe, axe.des desAxe, comp.des competencedes, dtable1.lien competenceid
FROM dtable dtable1, pers_v persv, volet volet1,pers pers1,dtable comp,dtable axe
WHERE dtable1.id = persv.id_table
AND persv.id_pers IN (1828)
AND persv.id_volet IN (162162, 162166, 162164)
AND volet1.type = 'COMP'
AND persv.id_volet = volet1.id
AND persv.id_pers = pers1.id
AND dtable1.lien =comp.id
AND axe.id =comp.lien) tmp
ORDER BY desAxe,competencedes |
Partager