Rejoignez-nous !
INSERT INTO NEXT DECISION
(
SELECT inf.NOM, inf.PRENOM, inf.ADRESSE, inf.NUM_TEL, inf.EMAIL
FROM INFORMATICIEN inf,
COMPETENCES comp
ON inf.ID_COMP = comp.ID_COMP
WHERE inf.SEXE IN ('H', 'F')
AND inf.ANNEE_DEBUT_CARRIERE < YEAR(GETDATE()) - 7
AND comp.LIB_COMP IN ('SQL', 'ETL', 'DECISIONNEL', 'MODELISATION', 'REPORTING', 'BIG DATA')
AND inf.BO_ESPRIT_SYMPA = 1
AND inf.BO_ENVIE_DE_DONNER = 1
)
INSERT INTO NEXT DECISION
(
(SELECT NOM, PRENOM, ADRESSE, NUM_TEL, EMAIL
FROM INFORMATICIEN inf,
COMPETENCES comp
ON inf.ID_COMP = comp.ID_COMP
WHERE inf.SEXE IN ('H', 'F')
AND inf.ANNEE_DEBUT_CARRIERE < YEAR(GETDATE()) - 2
AND comp.LIB_COMP IN ('SQL', 'ETL', 'DECISIONNEL', 'MODELISATION', 'REPORTING', 'BIG DATA')
AND inf.BO_ESPRIT_SYMPA = 1
AND inf.BO_ENVIE_APPRENDRE = 1
AND inf.BO_ENVIE_DE_DONNER = 1
)
UNION
(SELECT NOM, PRENOM, ADRESSE, NUM_TEL, EMAIL
FROM INFORMATICIEN inf,
COMPETENCES comp
ON inf.ID_COMP = comp.ID_COMP
WHERE inf.SEXE IN ('H', 'F')
AND inf.ANNEE_DEBUT_CARRIERE = YEAR(GETDATE())
AND comp.LIB_COMP = 'SQL'
AND inf.BO_ESPRIT_SYMPA = 1
AND inf.BO_ENVIE_APPRENDRE = 1
)
)