1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
|
SelectFrom = " SELECT Nom_Candidat,Prenom_Candidat,Libelle_Metier,Email_Candidat,Reponse_Document FROM Metier,Metier_Candidature,Candidature,Document,Candidat"
LiaisonDesTables = "WHERE Metier_Candidature.IDMetier_Metier_Candidature = Metier.IDMetier AND Metier_Candidature.IDCandidature_Metier_Candidature = Candidature.IDCandidature AND Candidature.IDCandidat_Candidature = Candidat.IDCandidat AND Document.IDCandidature_Document = Candidature.IDCandidature"
ConditionDeSelectionMETIER = "AND Metier.IDMetier = " + COMBO_Metier
ConditionDeSelectionEMAIL = "AND Candidat.Email_Candidat LIKE " + SAI_Mail
ConditionDeSelectionNOM = "AND Candidat.Nom_Candidat LIKE " + SAI_Nom
sConditionsDeSelection = ConditionDeSelectionEMAIL + ConditionDeSelectionNOM + ConditionDeSelectionMETIER
sMaRequeteSQL = SelectFrom + LiaisonDesTables + sConditionsDeSelection
// sMaRequeteSQL = " SELECT Nom_Candidat,Prenom_Candidat,Libelle_Metier,Email_Candidat,Reponse_Document FROM Metier,Metier_Candidature,Candidature,Document,CandidatWHERE Metier_Candidature.IDMetier_Metier_Candidature = Metier.IDMetier AND Metier_Candidature.IDCandidature_Metier_Candidature = Candidature.IDCandidature AND Candidature.IDCandidat_Candidature = Candidat.IDCandidat AND Document.IDCandidature_Document = Candidature.IDCandidature" |
Partager