SELECT T_Consultant.ID_CONSULTANT, T_Consultant.NOM_CONSULTANT FROM T_Consultant WHERE T_Consultant.ID_CONSULTANT =
(SELECT T_Consultant.ID_CONSULTANT, T_ConsultantActivite.ID_CONSULTANT, T_ConsultantActivite.ID_ACTIVITE, T_Consultant.NOM_CONSULTANT, T_Consultant.PRENOM_CONSULTANT, R_RechConsultantSecteur1.ID_CONSULTANT, R_RechConsultantSecteur1.ID_ACTIVITE, R_RechConsultantSecteur2.ID_CONSULTANT, R_RechConsultantSecteur2.ID_ACTIVITE, R_RechConsultantAttachFonc1.ID_CONSULTANT, R_RechConsultantAttachFonc1.ID_ACTIVITE, R_RechConsultantAttachFonc2.ID_CONSULTANT, R_RechConsultantAttachFonc2.ID_ACTIVITE, R_RechConsultantCompetence1.ID_ACTIVITE, R_RechConsultantCompetence1.ID_CONSULTANT, R_RechConsultantCompetence2.ID_ACTIVITE, R_RechConsultantCompetence2.ID_CONSULTANT
FROM T_Consultant, T_ConsultantActivite, R_RechConsultantSecteur1, R_RechConsultantSecteur2, R_RechConsultantAttachFonc1, R_RechConsultantAttachFonc2, R_RechConsultantCompetence1, R_RechConsultantCompetence2
WHERE T_Consultant.ID_CONSULTANT = T_ConsultantActivite.ID_CONSULTANT AND T_ConsultantActivite.ID_CONSULTANT = R_RechConsultantSecteur1.ID_CONSULTANT AND T_ConsultantActivite.ID_CONSULTANT = R_RechConsultantSecteur2.ID_CONSULTANT AND T_ConsultantActivite.ID_CONSULTANT = R_RechConsultantAttachFonc1.ID_CONSULTANT AND T_ConsultantActivite.ID_CONSULTANT = R_RechConsultantAttachFonc2.ID_CONSULTANT AND T_ConsultantActivite.ID_CONSULTANT = R_RechConsultantCompetence1.ID_CONSULTANT AND T_ConsultantActivite.ID_CONSULTANT = R_RechConsultantCompetence2.ID_CONSULTANT);
Partager